Datasheet
Making a Worksheet “Very Hidden”
You probably already know how to hide a worksheet: Just right-click the sheet tab and
choose Hide Sheet from the shortcut menu. And, of course, it’s just as easy to unhide a
sheet: Right-click any sheet tab and choose Unhide from the shortcut menu. (You see a list
of all hidden sheets.)
To make it more difficult for the casual user to unhide a hidden sheet, make the worksheet
“very hidden.” Here’s how to do it:
1. First, make sure that the Developer tab of the Ribbon is displayed. (By default, this tab
is not displayed.) To turn on the Developer tab, open the Excel Options dialog box
(choose Office ➪ Excel Options), click the Popular tab, and select the Show Developer
Tab in the Ribbon check box.
2. Activate the sheet you want to hide.
3. Click Developer ➪ Controls ➪ Properties to display the Properties window (see
Figure 25-1).
Figure 25-1: Use the Properties window to make a worksheet very hidden.
4. In the Properties window, click the Visible property to display a down-arrow button;
click the button to display a drop-down list and select 2 -xlSheetVeryHidden.
After performing these steps, you find that you cannot unhide the sheet by using any Excel
command. In fact, you cannot even unhide the sheet by using the Properties window. The
Properties window shows the properties of the active sheet. When a sheet is hidden, it’s
never the active sheet.
Tip 25: Making a Worksheet “Very Hidden”
64
04_137666 ch01.qxp 5/22/07 7:31 PM Page 64