Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
preventing access to hidden worksheets
I have hidden worksheets on my program. How can I prevent someone from
unhiding a worksheet? I know how to protect the worksheet from changes but there are certain worksheets I want to keep from others eyes. Thanks Glenn |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
preventing access to hidden worksheets
You can protect the workbook's structure.
This'll stop the user from inserting/deleting/renaming/moving sheets. In xl2003, you can find it under: Tools|Protection|protect workbook|Check Structure Leave Windows unchecked. Give it a memorable password. But be aware that this password is easily broken by anyone who really wants to. Glenn wrote: I have hidden worksheets on my program. How can I prevent someone from unhiding a worksheet? I know how to protect the worksheet from changes but there are certain worksheets I want to keep from others eyes. Thanks Glenn -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
preventing access to hidden worksheets
Set the worksheets property to xlVeryHidden the user will not be able to
unhide them unless they are in vba which you can password protect. or use something like ActiveWorkbook.Worksheets(3)= (xlVeryHidden) "Glenn" wrote: I have hidden worksheets on my program. How can I prevent someone from unhiding a worksheet? I know how to protect the worksheet from changes but there are certain worksheets I want to keep from others eyes. Thanks Glenn |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
preventing access to hidden worksheets
ActiveWorkbook.Worksheets(3).Visible = (xlVeryHidden)
"Office_Novice" wrote: Set the worksheets property to xlVeryHidden the user will not be able to unhide them unless they are in vba which you can password protect. or use something like ActiveWorkbook.Worksheets(3)= (xlVeryHidden) "Glenn" wrote: I have hidden worksheets on my program. How can I prevent someone from unhiding a worksheet? I know how to protect the worksheet from changes but there are certain worksheets I want to keep from others eyes. Thanks Glenn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preventing other users from opening hidden worksheets | Excel Discussion (Misc queries) | |||
PREVENTING ACCESS TO A HIDDEN COLUMN | Excel Discussion (Misc queries) | |||
Linked Spreadsheets - Preventing Access to Source Sheet | Excel Discussion (Misc queries) | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
Preventing User Access to VB code | Excel Programming |