View Single Post
  #3   Report Post  
dominicb
 
Posts: n/a
Default


Good afternoon Slaya_cz

You could make this more secure by marking the sheets as xlVeryHidden.
To do this goto the VBE (alt + F11) and find the worksheet you want to
hide under the Projects window on the left. Then set the Visible
property (under the Property window) to 2 - xlSheetVeryHidden. This
method can be protected by right clicking on the file name in the
project window and selecting VBAProject Properties, and selecting the
protection tab, check the lock project for viewing box and enter your
password.

This method is much more secure than the Workbook structure protection,
but it can still be circumnavigated as can any of Excel's current
security settings.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=472030