How to have multiple users/prompts for multiple worksheets in the same workbook?

[kayathri]

Hello sweethearts!!

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.

[Winon]

Hello kayathri,

Wellcome to the Forum.

To start with, have a look at the attached WorkBook, and if you find it usefull then just change it to your liking.

Also see the "Please consider" note at the bottom of this post.

[kayathri]

Hi dear Winon
Thank you very much for your reply
It's very sweet of you to drop by and to leave a reply
I will try out the codes and ask you if I have any questions regarding my work
Thank tou very much...have a lovely day ahead sweety!!