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!!!
Re: Need help with my force enable macros code being autosaved
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
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Re: Need help with my force enable macros code being autosaved
Thank you for that information, I will be sure to do that next time!! Any help people!?!?! I was also thinking about potentially making it available for a "don't save" button on the sheet when it asks for a password at exit
Re: Need help with my force enable macros code being autosaved
This is what I have now, I got rid of the password at the bottom but i am having a lot of trouble with the saving feature. I can't have read only users saving this doc at all, whether overwriting it or saving as a copy
Bookmarks