UserInterfaceOnly issue - protected Sheet

Hello everyone

I need help with my workbook, i'm not entirely sure this problem wasn't posted before but I didn't find a solution to this.

I have a workbook with 6 sheets and only the first sheet is addressed to normal users, they have to input data in a questionnaire that has drop down lists etc.
What I need is to be able to run macros while sheet1 is protected. After a high user uprotects the sheet there is no need for anything else.

But i am not able to make it run, i get the error 1004.

The problem is that if I use Sheet1.Protect UserInterfaceOnly:=True it prompts me for a password, and I don't need this, because only a high user can unprotect the sheet and he already knows the password - so I need it to run but without prompting the user for a password.

Is this even possible? Or is there any other way to do this?
I need this first sheet to be protected - when the normal user inputs data, and unprotected when the high user uses it to modify data.


I already tried it in Workbook Open but it doesn't work as I need it to work.

any help would be greatly appreciated.
Thanks

I created the workbook, so... yes, I am

that's what i'm trying to avoid, because if the code is interrupted the worksheet could be left unprotected.

ok. But i have one question, until we get to the point of transmitting the workbook.

If I put in the Workbook Open Event the following code it prompts me for password when i open the Workbook, which is not what I need. I need to use the "protect/unprotect" button on the ribbon manually.

Private Sub Workbook_Open()

Sheet1.Protect UserinterfaceOnly:=True, AllowFormattingRows:=True

End Sub

isn't this how I should write the code?

thanks a lot. Now it's working.