Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide and password protect a worksheet
I am using 2003 and xp sp3.
I want to hide and password protect a worksheet in a workbook |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide and password protect a worksheet
"Oldjay" wrote: I am using 2003 and xp sp3. I want to hide and password protect a worksheet in a workbook Hello Oldjay: Go to Tools, Protection and then Protect sheet |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide and password protect a worksheet
A couple of possible solutions. You can hide the worksheet and then password
protect the workbook which is reasonably effective at keeping people out out your worksheet. Note that your workbook must be protected for this to work and the workbook passwords are relatively easy to break with code that is readily available. Another solution is to change the visible property of the worksheet with a macro. One option is to make the sheet very hidden. Doing this the worksheet does not show up anywhere via the standard XL menus. Additionally you can password protect the VB project to keep users out of the VBE which means that they can not easily unhide the sheet. All of that being said there is no 100% way to protect users from getting at the sheet. -- HTH... Jim Thomlinson "Oldjay" wrote: I am using 2003 and xp sp3. I want to hide and password protect a worksheet in a workbook |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Protect a Worksheet | Excel Discussion (Misc queries) | |||
How do you permanently hide and password protect a column? | Excel Discussion (Misc queries) | |||
password protect worksheet | Excel Discussion (Misc queries) | |||
hide a column in a worksheet and password protect | Excel Discussion (Misc queries) | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |