Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent unhide sheet
I know how to hide a sheet but i do i prevent a user from performing the
unhide? Does it have to be done using VB or hiding a particular toolbar? Thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent unhide sheet
You could protect the workbook.
Tools|Protection|Protect workbook|Check Structure (in xl2003 menus) But this kind of protection is easily broken. If you have information that shouldn't be seen by others, then don't put it into excel. If you have to put it in excel, then don't share that file with others. acss wrote: I know how to hide a sheet but i do i prevent a user from performing the unhide? Does it have to be done using VB or hiding a particular toolbar? Thanks, -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent unhide sheet
Hi,
Try this: 1. Right click any toolbar and turn on Control Toolbox 2. Click the Properties button 3. Change the Visible property to xlVeryHidden 4. Press Alt+F11 and select your workbook in the Project window. 5. Choose Tools, VBA Project Properties, 6. Choose Protection and check Lock project for viewing and add a password. 7. Close the file and reopen it. All passwords can be broken, but some are easier to break than others. -- Thanks, Shane Devenshire "acss" wrote: I know how to hide a sheet but i do i prevent a user from performing the unhide? Does it have to be done using VB or hiding a particular toolbar? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dropdown unhide sheet | Excel Discussion (Misc queries) | |||
How to hide/unhide a sheet? | Excel Discussion (Misc queries) | |||
HELP!! Unhide Sheet with Macro and focus on other sheet | Excel Discussion (Misc queries) | |||
Can't see sheet, and have tried unhide, etc? | Excel Worksheet Functions | |||
Prevent unhide of rows/columns w/out worksheet protection? | Excel Discussion (Misc queries) |