Need help with my force enable macros code being autosaved

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.

Hi, welcome to the forum

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I will add them for you - this time