View Single Post
  #3   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

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