hiding worksheets from certain users with passwords
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
|