Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password Protecting a worksheet
Can anyone tell me if there is a way to password lock only a specific
worksheet inside of a workbook? I would like all of my direct reports to be able to access the workbook but not be able to access a certain page within it, because it will contain associate personal information, unless they have a password. Thanks for any responses. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password Protecting a worksheet
You can Hide the sheet (Format - Sheet - Hide) then protect the workbook.
This wil disallow unhide. You would need to unprotect to allow unhide... "Conker10382" wrote: Can anyone tell me if there is a way to password lock only a specific worksheet inside of a workbook? I would like all of my direct reports to be able to access the workbook but not be able to access a certain page within it, because it will contain associate personal information, unless they have a password. Thanks for any responses. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password Protecting a worksheet
Excel's worksheet protection isn't made for this kind of thing. It's easily
broken and all that private data can be available to anyone who really wants it. If you have data that is sensitive and shouldn't be seen by others, then don't put it in excel. If you have to put it in excel, then don't share it with others. Conker10382 wrote: Can anyone tell me if there is a way to password lock only a specific worksheet inside of a workbook? I would like all of my direct reports to be able to access the workbook but not be able to access a certain page within it, because it will contain associate personal information, unless they have a password. Thanks for any responses. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Password Protecting a worksheet
Works like a charm! Accomplishes exactly what I needed! Thanks Sean!
"Sean Timmons" wrote: You can Hide the sheet (Format - Sheet - Hide) then protect the workbook. This wil disallow unhide. You would need to unprotect to allow unhide... "Conker10382" wrote: Can anyone tell me if there is a way to password lock only a specific worksheet inside of a workbook? I would like all of my direct reports to be able to access the workbook but not be able to access a certain page within it, because it will contain associate personal information, unless they have a password. Thanks for any responses. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need help password protecting a worksheet | Excel Discussion (Misc queries) | |||
password protecting worksheet | Excel Discussion (Misc queries) | |||
PASSWORD PROTECTING SECTIONS OF A WORKSHEET | Excel Discussion (Misc queries) | |||
Locking formulas without password protecting worksheet | Excel Worksheet Functions | |||
Password protecting a worksheet | Excel Worksheet Functions |