I am trying to create individual passwords for multiple sheets in an excel workbook. I have successfully passworded the mastersheet but am struggling to password the individual worksheets. Please help this is where i am at:
Please Login or Register to view this content.
Last edited by Leith Ross; 12-22-2014 at 07:53 PM. Reason: Added Code Tags
You might want to check out JB's neat password sheet:
Jerry's Beaucaires Excel Assists - Passwords on Multiple Sheets
I've used it for the launching point of a few projects, such as the accouting tool I've attached. Visible = xlVeryHidden is real sharp, prevent manual Unhiding of the worksheets. Admin password for this one is: admin
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Thanks a lot I have had a look at the JB's sheet the instruction code is different from mine. But thanks anyway I will see if i can get my head around it as I am under pressure to deliver
Perhaps:
I'd recommend indenting your code. Makes reading much easier.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks