- Open a new workbook.
- Click Sheet2's tab to select it.
- From the Format menu, choose Sheet.
- From the resulting submenu, choose Hide. Excel hides Sheeet2 and its tab.
- Switch to Excel's VBE (press [Alt]+[F11]).
- In the Project Explorer, select the sheet you want to hide. This time, hide Sheet3.
- 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.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.