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
|