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

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

I'm actually looking at trying to hide certain sheets from certain people.
I'm a technician and pretty good with Excel, but not this good. Would you
mind letting me know how you did this?

" wrote:

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

Something like this:

Private Sub Workbook_Open()

'...
masterpassword = "123456789" 'e.g.
If psw = masterpassword Then 'psw: password given by user
Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
wks.Unprotect 'if sheets are protected (add password option if
necessary)
wks.Visible = True
Next wks
Else 'other passwords
'your code to display sheets linked to users
End If
'...

End Sub

Regards,
Stefi


€žCarolyn at VW€� ezt Ã*rta:

I'm actually looking at trying to hide certain sheets from certain people.
I'm a technician and pretty good with Excel, but not this good. Would you
mind letting me know how you did this?

" wrote:

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