I have a workbook with about 50 sheets in it. I need to be able to protect all the sheets but also don't want the user selecting locked or unlocked cells. Below is the code that I have pieced together from other searching. Right now it is protecting the sheets but doesn't prompt for a password when un-protecting it. It also doesn't let you select but will have the cells highlighted from when it was saved. Thanks for any input and if you could also give code for unlocking the entire workbook at one time that would be appreciated.
Bookmarks