Hello, curious if this is an option. I have a file with 20 tabs that, using the below code, generates 20 separate files, one for each tab. Is it possible to add code so that each of those files are password protected automatically, so that I do not have to open each file, and save as with a password?
Thanks so much for any assistance.
Sheryl
HTML Code:
Hi there,
Try modifying your SaveAs statement as follows:
Please Login or Register to view this content.
Hope this helps - please let me know how you get on.
Regards,
Greg M
Hi Sheryl,
It should be a simple case of recording the steps to lock & password protect one of the new files and then add that generated code into your existing macro. Said quickly that doesn't sound too bad although the devil is as always in the detail.
I would have actually done it for you if you had posted an example of your spreadsheet as well as the code snippet in your post
(I just saw Greg post and realised that I was looking at how to lock cells and protect the sheet rather than adding a simple password
Cheers
Jmac1947
1. Please consider clicking on the * Add Reputation if you think this post has helped you
2. Mark your thread as SOLVED when question is resolved
Ooooo that was easy, thank you!!!
Hi again,
Many thanks for your very prompt feedback and also for the Reputation increase - much appreciated!
You're welcome - glad I was able to help.
Best regards,
Greg M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks