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
|