Okay so I am no way a macros person and have barely used until the other day. A client has a shared workbook that needs to be password protected, but have a read only option. I then made the save buttons password protected so they couldn't save it as a copy. This macro I found online doesnt show them other sheets until they enable macros. My problem is it wants to auto save and asks for a password but not everyone will have the password. I see the macro has this situation covered but it's not working for me. Help would be greatly appreciated!!!
Please Login or Register to view this content.