Google Exceltip.com
Account Icon
Shopping Cart
CheckOut

» Hide an excel sheet without the option of unhiding it using VBA in Microsoft Excel

Tip submitted by Kedar Kulkarni, Pune India


To hide a sheet so that no body can unhide it without knowing the password for the Vb Project, simply open the VB Editor and change the visible property to 2 i.e. xlsheetveryhidden.

The sheet should disappear from the Unhide sheets command.

The only way to unhide it is to change the property back to 0 i.e. xlSheetNormal using the password to the VBProject.

Screenshot // Hide an excel sheet without the option of unhiding it using VBA in Microsoft Excel

Hide an excel sheet without the option of unhiding it using VBA in Microsoft Excel
Rate this tip
12 34 5
  RATING: 3.64
  VIEWS: 52668
  No comments have been submitted.


REGISTERED USERS click here to post comments


GUESTSclick here to Register
Name
Comment Title
Comments


Terms and Conditions of use
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation