Password protect to hide sheets and visible only to the right worker

[rama1209]

I have a sheet with multiple sheets for different employees. When the workbook is opened I want the employee to be able to see only his/her sheet. The manager should be able to see all sheets. The sheets should be password protected so that only the correct sheet is displayed to the right employee.
PS I wish I can upload my files so that you can see what I mean. I hope this message is clear.

 

[Zack Barresse]

Hi there,

Let me ask you a question first. If you're wanting to password protect sheets, where will you store your passwords? You could store it in the VBA code, but anyone who presses Alt + F11 will see the passwords for everybody. If you password protect your VBProject, you'll keep out a lot more people, but it's still not 100% secure. If you're going to store passwords not in the same file, where would they be? And would those people have access to that location? If so, again, not secure. You could always just go by the account which is logged in, but if somebody is accessing from another persons computer (if they have their password) then again, not secure.

Think about it and post back your thoughts. Each would come with a very different approach.

 

[rama1209]

Can I upload my file to show what I am trying to do ?

 

[Zack Barresse]

You should be able to. Click the Post Rely button, you can't do it in the Quick Reply window.

 

[rama1209]

http://www.box.net/files#/files/0/f/76062910/1/f_675113830
Can you please help me in a code to unhide sheets based on passwords. Only the manager should be able to see all sheets. The user whose name it is should onlybe able to unhide and see the sheet with their name. Nobody should be able to see or change code. Help is really apprecaited
Thanks

 

[rama1209]

i had to use a link I could not upload the files.

 

[dewanna]

The link that your sent need to login with password. So we could'nt get your file

 

[rama1209]

Sorry...

Here is the gist of it:



Name Cash Compuer total Diff Denom. Qty total denom qty tot..
John 10 11 -1 5 1 5 10 1 10
Ed 12 9 3 1 5 5 .25 8 2
Ram 14 14 0 10 12


Total deposit John Ed
Sheet name sheet name Sheet name

Lets say I have 4 sheets called Total deposit, John, Ed, Ram. I want only user 'Manager' to see the workbook. User 'John' can only see and work on sheet 'John'. User 'Ed' can only see and work on sheet 'Ed'.
Nobody can view or change code. I need help in coding that please.

 

[brockk]

Hi... not sure if this is what your asking for but, you might want to take a view at the following link.... HTH!

http://www.mrexcel.com/forum/showthread.php?t=422843

 

[ndendrinos]

try this:
http://www.box.net/shared/ioysat691i

Manager's password = monia
Sheet1 password=peter
Sheet2 password=mary