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
|