Hide Sheet
activesheet.visible=xlveryhidden
to unhide worksheets("Sheet1").visible=true -- HTH Bob Phillips "AA2e72e" wrote in message ... How can a sheet be hidden such that it cannot be unhidden via Format | Sheet | Unhide? |
Hide Sheet
And don't forget to protect the VBA project, as otherwise they will be able to go into the VBE,
see that a hidden sheet exists and write their own piece of code to show it if they know how. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- "Bob Phillips" wrote in message ... activesheet.visible=xlveryhidden to unhide worksheets("Sheet1").visible=true -- HTH Bob Phillips "AA2e72e" wrote in message ... How can a sheet be hidden such that it cannot be unhidden via Format | Sheet | Unhide? |
Hide Sheet
for a worksheet, they can just click on the sheet in the project explorer,
select properties and change visible from xlSheetVeryHidden to xlSheetVisible. Regards, Tom Ogilvy "Ken Wright" wrote in message ... And don't forget to protect the VBA project, as otherwise they will be able to go into the VBE, see that a hidden sheet exists and write their own piece of code to show it if they know how. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP -------------------------------------------------------------------------- -- Attitude - A little thing that makes a BIG difference -------------------------------------------------------------------------- -- "Bob Phillips" wrote in message ... activesheet.visible=xlveryhidden to unhide worksheets("Sheet1").visible=true -- HTH Bob Phillips "AA2e72e" wrote in message ... How can a sheet be hidden such that it cannot be unhidden via Format | Sheet | Unhide? |
All times are GMT +1. The time now is 12:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com