username/password

[nicmarty]

Ok, What I need to do, is I will have a workbook with say 20 worksheets. On one worksheet, labeled "LogIn ID" I will have all the usernames in column A and the passwords beside each username in column b. in column C, I will have listed the worksheet name that the user will go to provided he has the correct username and password. All other sheets will be hidden. I also want one username and password that will unhide all sheets. I will protect the workbook so no one can unhide the worksheets if they click "Disable Macros" when they open the file. Please let me know if this makes sense or if I cannot do some of these things. I believe it can be done, I am just not exactly sure how. Thanks!

[rylo]

Hi

Say you have a list of the user logon ids in sheet1 column A, the passwords in column B and the sheet they can access in column C, then try

Please Login or Register  to view this content.

You can expand the code to open the relevant sheet etc.


rylo