Solved Only when Excel worksheet is protected, I get a runtime error - What is wrong

I am in the process of trying to create an input spreadsheet that will eventually be used to output a form similar to the System Specs sheets used here. For the most part I used dropdowns to allow for most selections. My issue at the moment is when I protect the worksheets, I get a runtime error -214702024809 (80070057), but if I unprotect it, it works fine (up to the limits of my Excel skills so far).

I think it has something to do with the ListBox ActiveX Control I am using. I tried to unprotect the button I created a number of different ways but none seemed to work. I am using (and trying to understand) some borrowed VBA code to get the dropdown of list boxes to select from. It is attributed within the code.

Any help would be appreciated.

The version of Excel I am using is pictured below.

The attached file is a macro-enabled Excel file that has been sheet protected. The password is: zx

Can anyone suggest another forum I could pose this question in?

You could try searching and, if necessary, posting in the Office section of TenForums.
Microsoft Office and 365 - TenForums
[Even though you are using Windows 11, this forum has no dedicated Office section so posting there will be better for you.]

I do urge you to make your question title more descriptive there so you attract the attention of somebody who know about creating forms in Excel.
And just state that you are using MSOffice Pro Plus 2021 instead of suggesting people read your pictures.

Best of luck,
Denis

Try3 said:

You could try searching and, if necessary, posting in the Office section of TenForums.
Microsoft Office and 365 - TenForums
[Even though you are using Windows 11, this forum has no dedicated Office section so posting there will be better for you.]

I do urge you to make your question title more descriptive there so you attract the attention of somebody who know about creating forms in Excel.
And just state that you are using MSOffice Pro Plus 2021 instead of suggesting people read your pictures.

Best of luck,
Denis

Click to expand...

Thanks for the suggestions. I figured as much when I initially posted here. I have been trying to get this to work for about two weeks now, at least 3 hours a day and it was getting a bit frustrating. I had received some good responses here in the past and was just hoping it might be the same again. I am a member on Tens Forum, so I will give that a try.

As for the title, any suggestions? I thought this was concise and I also ran out of space trying to add more to it.

As for the picture, I get that, but there was more info than just the title in it that I thought would help. I had also thought the pictures would be inline.

You could try
Runtime error with new Excel form on protected worksheet


Best of luck,
Denis