View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default hiding worksheets from certain users with passwords

Apply a master password known only to the privileged user and make all sheets
visible when getting this password!

Regards,
Stefi



ezt *rta:

hi there.

i've managed to set up an excel workbook where upon opening, it asks
you for a password and displays a certain sheet linked that user. this
user then cannot unhide or view the other worksheets in the workbook.
my problem is i want to enable some users to be able to see all the
worksheets in a workbook. ie all worksheets are visible to one user.
does anyone have any ideas if this is possible?

any help much appreciated

kenny