If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Password protecting worksheets
How can I password protect a hidden sheet so that you can only 'unhide' it
with a password? I'm using Excel 2003. |
#2
|
|||
|
|||
Password protecting worksheets
Hi,
Once you hide the sheet you protect your worksheet, Tools protection, protect worksheet "VANH1027" wrote: How can I password protect a hidden sheet so that you can only 'unhide' it with a password? I'm using Excel 2003. |
#3
|
|||
|
|||
Password protecting worksheets
I don't quite follow. I hide the sheet that I don't want seen and protected
and then protect the rest of the workbook? It won't let me protect the hidden sheet without unhiding it. "Eduardo" wrote: Hi, Once you hide the sheet you protect your worksheet, Tools protection, protect worksheet "VANH1027" wrote: How can I password protect a hidden sheet so that you can only 'unhide' it with a password? I'm using Excel 2003. |
#4
|
|||
|
|||
Password protecting worksheets
It would take some Visual Basic to do what you ask.
So what you might want to do is... 1) Protect the worksheet 2) 'VERY HIDE' the worksheet so that it does NOT appear when you select 'FORMAT SHEET UNHIDE' To do this... 1) Protect the worksheet - TOOLS PROTECTION PROTECT SHEET - The 'Protect Sheet' window will appear - Make sure the 'Protect worksheet and contents of locked cells' check box is checked - Enter a password in the 'Password to unprotect sheet' text box - WRITE THE PASSWORD DOWN SOMEWHERE! - Uncheck ALL checked boxes in the 'Allow all users of this worksheet to:' check boxes - Select 'OK' - Re-enter password in the 'Reenter password to proceed.' text box 2) 'VERY HIDE' the worksheet - TOOLS MACRO VISUBAL BASIC EDITOR - Press the 'Ctrl' key and the 'R' key at the same time [Ctrl-R] so that the 'Project - VBAProject' window appears on the left side of the Visual Basic window. - Press the 'F4' function key so that the 'Properties Window' will appear on the left side of the Visual Basic window. - In the 'Project - VBAProject' window, find the worksheet you just protected and highlight it. - When you highlight the worksheet, the 'Properties Window' will change to show the properties of that worksheet. - In the 'Properties Window', scroll down to the last item. It should say 'Visible' on the left side of the window and '-1 - xlSheetVisible' on the right side of the window. - Select the dropdown and highlight '2 - xlSheetVeryHidden' - FILE CLOSE AND RETURN TO MICROSOFT EXCEL This is about the best you're going to be able to do without macros. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "VANH1027" wrote: I don't quite follow. I hide the sheet that I don't want seen and protected and then protect the rest of the workbook? It won't let me protect the hidden sheet without unhiding it. "Eduardo" wrote: Hi, Once you hide the sheet you protect your worksheet, Tools protection, protect worksheet "VANH1027" wrote: How can I password protect a hidden sheet so that you can only 'unhide' it with a password? I'm using Excel 2003. |
#5
|
|||
|
|||
Password protecting worksheets
Thank you SOOO much! It seems so easy when you explain it like that... Haha
"Gary Brown" wrote: It would take some Visual Basic to do what you ask. So what you might want to do is... 1) Protect the worksheet 2) 'VERY HIDE' the worksheet so that it does NOT appear when you select 'FORMAT SHEET UNHIDE' To do this... 1) Protect the worksheet - TOOLS PROTECTION PROTECT SHEET - The 'Protect Sheet' window will appear - Make sure the 'Protect worksheet and contents of locked cells' check box is checked - Enter a password in the 'Password to unprotect sheet' text box - WRITE THE PASSWORD DOWN SOMEWHERE! - Uncheck ALL checked boxes in the 'Allow all users of this worksheet to:' check boxes - Select 'OK' - Re-enter password in the 'Reenter password to proceed.' text box 2) 'VERY HIDE' the worksheet - TOOLS MACRO VISUBAL BASIC EDITOR - Press the 'Ctrl' key and the 'R' key at the same time [Ctrl-R] so that the 'Project - VBAProject' window appears on the left side of the Visual Basic window. - Press the 'F4' function key so that the 'Properties Window' will appear on the left side of the Visual Basic window. - In the 'Project - VBAProject' window, find the worksheet you just protected and highlight it. - When you highlight the worksheet, the 'Properties Window' will change to show the properties of that worksheet. - In the 'Properties Window', scroll down to the last item. It should say 'Visible' on the left side of the window and '-1 - xlSheetVisible' on the right side of the window. - Select the dropdown and highlight '2 - xlSheetVeryHidden' - FILE CLOSE AND RETURN TO MICROSOFT EXCEL This is about the best you're going to be able to do without macros. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "VANH1027" wrote: I don't quite follow. I hide the sheet that I don't want seen and protected and then protect the rest of the workbook? It won't let me protect the hidden sheet without unhiding it. "Eduardo" wrote: Hi, Once you hide the sheet you protect your worksheet, Tools protection, protect worksheet "VANH1027" wrote: How can I password protect a hidden sheet so that you can only 'unhide' it with a password? I'm using Excel 2003. |
#6
|
|||
|
|||
Password protecting worksheets
I think Eduardo meant for you to hide the sheet then protect the WORKBOOK.
If you protect the workbook with a password under ToolsProtectionProtectWorkbook, users cannot unhide hidden sheets without unprotecting the workbook. You don't need to protect the worksheet. Gord Dibben MS Excel MVP On Thu, 26 Feb 2009 12:28:02 -0800, VANH1027 wrote: I don't quite follow. I hide the sheet that I don't want seen and protected and then protect the rest of the workbook? It won't let me protect the hidden sheet without unhiding it. "Eduardo" wrote: Hi, Once you hide the sheet you protect your worksheet, Tools protection, protect worksheet "VANH1027" wrote: How can I password protect a hidden sheet so that you can only 'unhide' it with a password? I'm using Excel 2003. |
Thread Tools | |
Display Modes | |
|
|