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.

 

[rama1209]

Can I send you my file...I copied the code over and it is not hiding the sheets. It is also not asking for the user name. How do I send the file across?

 

[ndendrinos]

To upload a file go to :
http://www.box.net/
sign up for an account (free) and then upload your file.
choose to "share it" then copy the link to the file and post it here

 

[rama1209]

http://www.box.net/shared/un563sf71q
Can somebody please look at the code.
I want the admin/manager to be able to see all worksheets. Each user should be able to view only their files (ie Niraj, Umer, Chaya etc...) When they are done, the sheet should be hidden.
The password they enter should not be visible. I do not know how to do it. The workbook should open to an empty sheet., where if the username and password is correct then the user can view, work and edit his shhet. WHen done, it should save and hide and link the infomration to the sheet marker total deposit.
Please advise and/or show me
Thanks

 

[grizz]

your code works fine you have it in sheet 1 NIRAJ
you also have it ( very hidden ) when I opened it --- it as for password to view

 

[ndendrinos]

cannot read your file as I use Excel2002
Were you able to read mine?
It does what you want except:
The passwords are NOT "*****"
and the transfer of data to "Total Deposits" well that I leave to someone else that can open your upload on Box.Net

Good luck

 

[Zack Barresse]

Your workbook is password protected. How are we supposed to see your data structure if you have it locked down? I don't really want to hack your file.

Anyway, a basic synopsis might be something like: hide all user worksheets on close (in case macros are disabled when the file is opened the next time), on open ask for a username password (I see you have a userform for that already), based on the entry (if correct), unhide that sheet only, and on close (again) hide all user worksheets.

 

[rama1209]

<HR style="BACKGROUND-COLOR: #ffffff; COLOR: #ffffff" SIZE=1> <!-- / icon and title --><!-- message -->
http://www.box.net/shared/un563sf71q
I am sorry. But in the latest thread there is no password. I really appreciate you looking at this for me. I am not familiar with VB.
Basically, I want only Manager/admin to view total deposit. User Niraj should only be able to view (hide/unhide) his sheet. When the workbook saves , the sheet should be hidden. Similarly user Umer should only be able to view his sheet.....
Thanks for your help

 

[Zack Barresse]

Clicked the link in your latest post to download the file and it says it isn't there. ??

 

[rama1209]

Can you please look at this file. It does not seem to work more than a few times. Thnaks
user Manager
p/w secret
http://www.box.net/shared/t999283714

 

[Zack Barresse]

There's a password on the VBA Project? How are we supposed to see what your code is and amend it? Please do not post files which are password protected, hence do not post anything which isn't public knowledge, as this is a public board. If you have sensitive information you do not wish to share, you may want to think about hiring someone to do this for you. As for me, I won't hack your file just to give you code. Sorry.