Wednesday, 7 November 2012

How to hide excel sheets - Tips from Susan Harkins

Wednesday, 7 November 2012

Placing this in my blog so that I won't forget where to find the tips again...

Excerpts from Tech Republic : How to hide excel sheets

Excel has a more secure setting known as “very hidden.” A very hidden worksheet can’t be unhidden using the Excel user interface because it doesn’t appear in the Unhide dialog box. The average user won’t even know the sheet exists, let alone know how to unhide it. You’ll need the VBE to apply this property as follows:

  1. Switch to Excel’s VBE (press [Alt]+[F11]), then press F4 to display the property box.
  2. In the Project Explorer, select the sheet you want to hide. This time, hide Sheet3.
  3. In the Properties window, select 2 - xlSheetVeryHidden from the Visible property’s drop-down list. When you do, Excel applies the property and then selects the first sheet, Sheet1, which is a bit distracting. That behavior is normal, so don’t let it bother you.

When you return to Excel, Sheet3 isn’t visible. Nor does Excel list Sheet3 in the Unhide dialog box. In fact, Excel dims the Unhide command if the only sheets hidden are very hidden sheets. Sheet2 is visible because (earlier) we used the Hide command from the Format menu to hide it.

The result is a very stealthy sheet, but it’s still vulnerable to savvy users who know the technique.To unhide Sheet3, return to the VBE and choose -1 – xlSheetVisible. (That’s a negative 1, which denotes the constant’s value.)


Post a Comment


Related Posts with Thumbnails