User form to log in and unhide certain sheets

[dmooreh70]

Hello,

I am attempting to adjust the attached code to suit my needs. As the code currently stands you enter one username/password combination which in turn "unlocks" one sheet.

UserName: user1
Password: u1pass

I would like to be able to have each user gain access to several different sheets when they enter their password. I would also like to have an admin log-in to unlock/unhide all sheets at once.

I have seen other people post similar questions, and I have certainly tested out a variety of different methods based on those threads, but none seem to get the job done for me.

Any assistance would be greatly appreciated.

Thanks

[ranman256]

but if they 'break' the code , couldnt they see all the password(s)?

[dmooreh70]

I typically would password protect the VBA project so that they would not have access to the code. I left it unprotected for now. Also, most of the people who would be using this spreadsheet are not that skilled with Excel to my knowledge.

[dmooreh70]

I ended up scrapping the whole idea of using user names and passwords. I just wrote a simple macro to export each user's specific set of sheets to a new workbook, remove all the links/formulas and just keep the values and then save it as their name. That way nobody has access to anything they shouldn't.