So a friend of mine gave me a very large excel spreadsheet with lots of "Microsoft Excel Objects" and "Modules" in the VBA which contain the ThisWorkbook.Protect lines. I'm assuming this is what is causing me problems and re-protecting the sheet once I move to another. Unfortunately its a file I cannot share and was wondering if anyone has had experience with this? He told me the password but its a pain to enter it everytime when I right-click the sheet name to unprotected. I've gone though all the steps and I go to review>unprotected workbook & sheet>password accepted and unlocked then I go to another sheet and do the same but go back and its protected again. I was wondering if there was a way to remove the password protection from the 30ish Modules safely? Or is there another way around this?
Bookmarks