Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding a sheet
Hello
I once read somewhere you can 'double' hide as sheet so that it can't be seen within a workbook. How do you do this Thanks in advance James |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding a sheet
Hi James,
You set it's visible property to xlVeryHidden, like so ACtiveSheet.Visible = xlVeryHidden It is re-instated from VBA with = True as normal, but it can't be unhidden in Excel. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "James L" wrote in message ... Hello, I once read somewhere you can 'double' hide as sheet so that it can't be seen within a workbook. How do you do this? Thanks in advance, James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding columns in a protected sheet | Excel Discussion (Misc queries) | |||
Hiding rows on a sheet before printing | Excel Worksheet Functions | |||
Hiding sheet in a workbook | Excel Worksheet Functions | |||
hiding all data in a sheet except desired | Excel Worksheet Functions | |||
Hiding A Sheet Command Button With VBA | Excel Programming |