Cannot unprotect a worksheet

[kafka]

I have a worksheet which requires a password to open. I don't want this and have gone through the usual procedure for unprotecting it. Although the buttons under Review tell me that it is unprotected (both show Protect Worksheet and Protect Workbook rather than Unprotect), it still requires a password to open. Help!

 

[rollis13]

This is most likely because the code for the password request is in a macro in the ThisWorkBook module and is triggered by the "Workbook_Open" or "Auto_Open" event.

 

[Peter_SSs]

@rollis13
Did you notice this in your post?

I have fixed it for you. FYI, it is caused by the shortcut for that 'smilie' being o_o
For the future, you can fix that by enclosing those characters, or the whole Auto_Open text (or more) with [plain][/plain] tags

 

[rollis13]

Thanks @Peter_SSs, in truth I just clicked 'Post reply' and closed the window and probably I would've noticed it this morning (for me) since every now and then I check my posts but it would've been too late to edit .

 

[RoryA]

Although the buttons under Review tell me that it is unprotected (both show Protect Worksheet and Protect Workbook rather than Unprotect)

Those options are unrelated to the password for opening a workbook. With the workbook open, select File - Info, click the Protect Workbook dropdown and select the Encrypt workbook option, then clear the contents of the password box in the dialog that appears and save the workbook.