View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Office_Novice Office_Novice is offline
external usenet poster
 
Posts: 245
Default preventing access to hidden worksheets

ActiveWorkbook.Worksheets(3).Visible = (xlVeryHidden)

"Office_Novice" wrote:

Set the worksheets property to xlVeryHidden the user will not be able to
unhide them unless they are in vba which you can password protect. or use
something like

ActiveWorkbook.Worksheets(3)= (xlVeryHidden)

"Glenn" wrote:

I have hidden worksheets on my program. How can I prevent someone from
unhiding a worksheet? I know how to protect the worksheet from changes but
there are certain worksheets I want to keep from others eyes.
Thanks
Glenn