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
|