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 translations Article translations
Article ID: 928989 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

Consider the following scenario. You turn off the following Display options for this workbook options in Microsoft Office Excel 2007:
  • Show horizontal scroll bar
  • Show vertical scroll bar
  • Show sheet tabs
You press CTRL+F11 to add a macro sheet to the workbook. If you then turn on the Display options for this workbook option Show sheet tabs, and then click the Sheet1 tab, all the worksheet tabs disappear.

Note The tabs reappear when you move the pointer over the location of the worksheet tabs.

WORKAROUND

To work around this issue, use one of the following methods.

Method 1: Minimize and then restore the workbook window

To do this, follow these steps:
  1. Click the Minimize Window button next to the Microsoft Office Excel Help button to minimize the workbook window.
  2. On the minimized worksheet, click the Restore Up button or the Maximize button to restore the workbook window.

Method 2: Press ALT+TAB

If multiple workbooks are open, press ALT+TAB to change between workbooks.

Method 3: Click the workbook buttons in the taskbar

If multiple workbooks are open, click the workbook buttons in the taskbar to change between workbooks.

Method 4: Open or create a new workbook

In addition to the workbook that contains the macro worksheet, open an existing workbook, or create a new workbook.

Method 5: Change the Zoom settings

Change 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:
  • Click Zoom Out or Zoom In on the status bar.
  • On the View tab, click Zoom in the Zoom group, select the setting you want under Magnification, and then click OK.

Properties

Article ID: 928989 - Last Review: October 15, 2007 - Revision: 1.1
APPLIES TO
  • Microsoft Office Excel 2007
Keywords: 
kbtshoot kbprb kbexpertisebeginner KB928989

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com