Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Worksheet tabs disappear when you change some "Display options for this workbook" options and then add a macro worksheet to a workbook in Excel 2007
Article ID: 928989 - View products that this article applies to.
Consider the following scenario. You turn off the following Display options for this workbook options in Microsoft Office Excel 2007:
Note The tabs reappear when you move the pointer over the location of the worksheet tabs.
To work around this issue, use one of the following methods.
Method 1: Minimize and then restore the workbook windowTo do this, follow these steps:
Method 2: Press ALT+TABIf multiple workbooks are open, press ALT+TAB to change between workbooks.
Method 3: Click the workbook buttons in the taskbarIf multiple workbooks are open, click the workbook buttons in the taskbar to change between workbooks.
Method 4: Open or create a new workbookIn addition to the workbook that contains the macro worksheet, open an existing workbook, or create a new workbook.
Method 5: Change the Zoom settingsChange the Zoom setting to a different setting. Then, change the Zoom setting back to the preferred setting.
To do this, use one of the following methods: