hi, I have created a dropdown menu with a series of names on it. Once another user clicks their name, I am attempting to have them enter a password so that they can only access their data in the sheet and no one else's. How do I do this?

hi, I have created a dropdown menu with a series of names on it. Once another
user clicks their name, I am attempting to have them enter a password so that
they can only access their data in the sheet and no one else's. How do I do
this?

Hide all the sheets except the login sheet;

When user selects name from the dropdown,
prompt for a password;

If the password belongs to that name,
show the sheet[s] listed that user is allowed to access;
this info should be stored on a VeryHidden sheet;

Use the Workbook_BeforeClose event to hide all sheets except login sheet.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion