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 |
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 |
All times are GMT +1. The time now is 06:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com