View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Black Paul Black is offline
external usenet poster
 
Posts: 394
Default 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