Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open workbook, display certain sheets
Is there any way to display certain sheets with a certain password on
the opening of a workbook? For example, if user X enters in the password "hello", then only sheets pertaining to X are displayed, all other sheets remain very hidden. If user Y enters in the password "morning" then only sheets pertaining to Y are displayed and all other sheets remain very hidden. If no password is entered, or macros are disabled, then only the home sheet is displayed, all others are very hidden. I'm so close to figuring it out, and I'm relatively new at this. Can anyone help? Thanks a lot- jerry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
open workbook, display certain sheets
Jerry:
you have to do the control yourself you need a dialog form that opens and asks for the user name and password you then need to check these some how i would suggest ona very hidden form that somebody can maintain. you then need to make a list of the visible sheets that the users can see and unhide the ones that the user can see. you need to set your sheets to very hidden for the ones that are hidden and protect the workbook and the project. you alos need to deal with saving so you need to hid the sheets when a save is done so that the protection is not broken (and then unhide them if the user did not close the file). Something to do over the weekend??? -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. " wrote: Is there any way to display certain sheets with a certain password on the opening of a workbook? For example, if user X enters in the password "hello", then only sheets pertaining to X are displayed, all other sheets remain very hidden. If user Y enters in the password "morning" then only sheets pertaining to Y are displayed and all other sheets remain very hidden. If no password is entered, or macros are disabled, then only the home sheet is displayed, all others are very hidden. I'm so close to figuring it out, and I'm relatively new at this. Can anyone help? Thanks a lot- jerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to display message,when open workbook | Excel Discussion (Misc queries) | |||
display alert when workbook open | Excel Programming | |||
Shared Workbook with user code lookup to display sheets | Excel Programming | |||
Search open sheets in workbook and insert into open sheet | Excel Discussion (Misc queries) | |||
Open workbook with x number of sheets | Excel Programming |