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 |
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 |
Can you help me? hiding worksheets from certain users with passwo
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 |
Can you help me? hiding worksheets from certain users with passwo
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 |
All times are GMT +1. The time now is 06:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com