Password protecting an individual sheet in a workbook

Originally Posted by Nitro2481

Hey guys.

I'm working on a big workbook for my company. I want all staff to able to input there work on this workbook on certain sheets. I then have other sheets that are calculating salaries and commissions. These sheets are extremely sensitive and I don't want the staff having access to this info. I know you can hide sheets but Is there a way to password protect sheets.

Nitro.

Hi,

So this looks simple to me.

First hide all of the Sensitive Sheets and then Click 'Protect Workbook' button and provide a password.

This will disable the unhiding Sheets option.

Hope this answers your query.

Roy UK has a very useful file, just try it and see if it helps you!
http://www.excelforum.com/excel-prog...-workbook.html

Originally Posted by Nitro2481

Hi sakmsb,

Will the staff still be able to input on the other sheets without the protect workbook password?

i hope you meant *WITH the protect workbook password?

yes, they will be able to..

hi,
if you want to use it you need to change (in sheet Hide this sheet)the users name and the level.
i.e
Jack has level 1, it means he is able to access Sheet Dept1
Roy has level 2, it means he is able to access Sheets Dept2 and Dept3
and so on
you can see the code here:

Please Login or Register  to view this content.

you need to test it for yr needs

hi man.
1st you need to rename the sheets (Dept1,Dept2,Dept3 as what you want)
I renamed them as: Dept1 as Apples, Dept2 as Oranges, Dept3 as Grapes and added 2 new as Profit and Wages.
2nd replace the code from the orig file with this one

Please Login or Register  to view this content.

also using Manager as user and secret as password you can manage all sheets!
hope it helps you.

Hi Nitro,
I added the test file, this is the original Roy's file and it has "an amended piece of code" with your example posted in post#8
hope it helps you.

Hi John,

I can see that working ok. How do I apply it to my sheet. I viewed the code for each sheet but I cannot see the code you gave me inserted in any sheet, can this be retrospectively applied to a sheet already created or does it have to be set up at the start. I really need some hand holding / step by step on this one. If I could see where the codes have been input I could probably manipulate it to suit me. Do I need to set up a "splash" and "Hide this sheet" sheet. Not sure i'm getting this one. Sorry if I'm wrecking your head. Also I'm on 2003 if that matters?

Hi,
You need to set up a "splash" because when you open the file mandatory you need to have a sheet, a sort of "welcome" or some instructions for users or whatever.
You need to have a hidden sheet where you manage the users and level.
The sheets nned to be created/named before and then change the code for your needs.
To see the code, hit Alt+F11 and you will see in the left side a window, Microsoft Excel Object =your sheets, Forms=your UserForm (in this case is frmPW), if you double click on it you see the form itself, go to menu-View-Code, there is the code.
in post#8 you said:
" I want all staff when they open the workbook to see Apples, oranges, grapes" it means case1, and in sheet "Hide this sheet" you see user Jack, password x, level1.

Please Login or Register  to view this content.

you can change Jack with what you want and the pass code too.

"I logon I can see all 5"
it means case2, and in sheet "Hide this sheet" you see user Roy, pass code y, level2.
you can change Roy or the pass code too.

Please Login or Register  to view this content.

hope it helps you.

it's ok if you changed case 1 (Jack) to Advisor, pay attention just replace Jack with Advisor in the same cell in sheet "Hide..."
it's not ok if you deleted Roy and you change the code (case2), here you have two options:
sign in as Manager/secret and you are able to see all sheets
sign as george/wahtever pass code- instead of Roy and you are able to see sheets from case2.
to hide a sheet, Alt+F11, select the sheet and from properties window visible-> select 2 xlSheetveryhidden

Hi man,
Glad to help you!