Thursday, January 8, 2009

Very Hidden Worksheet in Excel


A very hidden worksheet is a sheet that won’t be displayed in Excel interface. Unlike proper hidden worksheet, a very hidden worksheet isn’t showed in unhide selection dialog box. How to make a very hidden worksheet:

  1. Open the workbook (excel file)
  2. Open Visual Basic editor by pressing Alt + F11
  3. If Project Explorer and Properties not showed, press Ctrl + R then F4 to activate
  4. Select worksheet you want to hide in Project Explorer then go to Properties, look for item Visible, change the value to 2 – xlSheetVeryHidden.
  5. Return to Excel by press Alt + Q.
Now your worksheet is in VeryHidden mode. You’ll not able to open, view or edit the worksheet unless you set it back from the Visual Basic editor by setting Visible item to original value. FYI, a very hidden worksheet is only invisible, it doesn’t protect your data from being stolen.

Comments :

2 comments to “Very Hidden Worksheet in Excel”

Dissertation Help said...
on 

This is extremely helpful info!!! Especially since you guys are offering it for free!! Very good listing. Everything is true. Thanx.
--------------------------------------------------
Dissertation Writing | Dissertation Advice

dissertation said...
on 

it's good to see this information in your post, i was looking the same but there was not any proper resource, thanx now i have the link which i was looking for my research.

UK Dissertations Help

 

Published by COMPUTER STUFF supported by DVD Writer USB