View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_8_] Roger Govier[_8_] is offline
external usenet poster
 
Posts: 376
Default Hiding worksheets

Hi Curtis

Right click on the sheet tabView CodeF4 to view the Properties
windowsscroll down to Visibleselect xlSheetVeryHidden from the
dropdown on the right.

A Very Hidden sheet, does not show VBA and lock the project with a
password to prevent them opening the VB Editor.

--
Regards
Roger Govier

Curtis wrote:
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