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

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