Page 103 - Excel 2007 Bible

08_044039 ch04.qxp 11/21/06 10:56 AM Page 60
Part I
Getting Started with Excel
Preventing Sheet Actions
o prevent others from unhiding hidden sheets, inserting new sheets, renaming sheets, copying sheets, or
Tdeleting sheets, protect the workbook’s structure:
1. Choose Review ➪ Changes ➪ Protect Workbook.
2. In the Protect Workbook dialog box, click the Structure option.
3. Provide a password, if you like.
After performing these steps, several commands will no longer be available when you right-click a sheet tab:
Insert, Delete, Rename, Move or Copy, Hide, and Unhide. Be aware, however, that this is a very weak secu-
rity measure. Cracking Excel’s protection features is relatively easy.
You can also make a sheet “very hidden.” A sheet that is very hidden doesn’t appear in the Unhide dialog box.
To make a sheet very hidden:
1. Activate the worksheet.
2. Choose Developer ➪ Controls ➪ Properties. The Properties dialog box, shown in the following
figure, appears. (If the Developer tab isn’t available, you can turn it on using the Popular tab of the
Excel Options dialog box.)
3. In the Properties box, select the Visible option and choose 2 - xlSheetVeryHidden.

After performing these steps, the worksheet is hidden and doesn’t appear in the Unhide dialog box.
Be careful! After you make a sheet very hidden, you can’t use the Properties box to unhide it because you
aren’t able to select the sheet! In fact, the only way to unhide such a sheet is to use a VBA macro. (See Part VI
for more information about VBA.) For example, this VBA statement unhides Sheet1 in the active workbook:
ActiveWorkbook.Worksheets(“Sheet1”).Visible = True

60