Forum Discussion
Password protected sheets can still be unprotected without password
I created a macro to password protect all sheets in my workbook. However, after doing so, you can still right-click on any sheet and unprotect it without being prompted for the password. How do I fix...
benk51987 Ran your code and it seems to do what you intend. Alls sheet becomes locked and can only be unlocked by the password entered.
Tested on a Mac (Catalina, Office365)
Riny_van_Eekelenthank you for your response. It's weird that mine is not working. I wonder if the spreadsheet has some other code in it somewhere that is causing a conflict? I don't know - I'm at a loss!
