View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 510
Default Hiding worksheets

Hi

Start VBA editor (Alt+F11). In VBA Project select sheet, and set it's
Visible property to xlSheetVeryHidden.

To prevent the user setting the sheets Visible property to xlSheetVisible
again, protect VBA Project with password.


Arvi Laanemets


"Curtis" wrote in message
...
Is there any way to keep users from un-hiding worksheets in a workbook?
However they do require access to other sheets (not hiiden) within the
workbook

Thanks
--
ce