Passwords for Hidden Worksheets
Hi Everyone,
I have a Workbook that will be Shared by 7 Users. Each User will have
a Specific Worksheet just for them.
I have Hidden the 7 Worksheets.
I have a Button on a Sheet Named "Logon" which I want Each User to
Click and Enter a Password that will Unhide JUST their Worksheet. I
would like a Macro that I can Attach to the Button that will Allow
this Please.
I Also have a Button on Each of the Worksheets, so when they have
Finished they will Click it and it will Re-Hide their Worksheet. I
would like a Macro to do this Please.
One Final thing, I need to be Able to Input a Master Password that
will Unhide ALL of the Hidden Worksheets Please.
Thanks for your Help in Advance.
All the Best
Paul
|