Login/Password Prompt for Multiple Users

Hey All

I was looking to set up a username/password protected workbook.
I was hoping if I can make certain sheets visible depending on the username.

so e.g
User 1 will only get access to Sheet1 but
User 2 will get acess to Sheet1 and Sheet 2

I will have about 30 users so I am assuming I would have to have a seperate sheet to store the login/password information or can it all be hidden in the VBA?

Optional: Would it be better if we set up a 3rd field called Type when prompting for login and password. Type would be "user","manager","owner".
All users will get access to Sheet 1 only.
Managers will get access to Sheet 1 and Sheet 2.
Owner will get access to Sheet 1, 2 and 3


Also, I would like to store the username in cell A1 of Sheet 1 as all calculations in this sheet will be based on this value.


Also, any tips on making the workbook more secure above and beyond the excel sheet/workbook password protection and password protection on the VBA as VERY welcome.


Any help on this is greatly appreciated.

Originally Posted by dominicb

Good evening manny_cb

I have a template available that does exactly what you require. It stores a list of users and passwords, and which sheets are to be accessed by which users. You, as administrator, can see all worksheets and control which sheets users can access.

The security on this isn't 100%, as we are using Excel, which by its very nature is not completely secure, but it should keep out most nosey parkers.

If you would like a copy of this template, then please PM me your e-mail address.

HTH

DominicB

Hello DominicB,,..

I was looking around in hundreds of posts for this subject and finally came across this post which is exactly what I was looking for. I'm hoping you would be able to help me out in this..

Thanks..