Microsoft KB Archive/231132

= XL2000: Worksheet Tabs Disappear When Selected =

Article ID: 231132

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q231132



SYMPTOMS
When you click a sheet tab in a workbook, all the sheet tabs disappear.



CAUSE
This problem occurs when the following conditions are true:


 * 1) You hide the horizontal scroll bar in the workbook.
 * 2) You protect a workbook and then hide the sheet tabs by using a macro.
 * 3) You unprotect the workbook and unhide the sheet tabs by using a macro.
 * 4) You select a sheet tab other than the active sheet tab by clicking the tab or by pressing CTRL+PAGE DOWN.



WORKAROUND
To work around this problem, resize the workbook by dragging the resize control in the lower-right corner of the workbook window. (You may need to click the Restore Window button in the upper-right corner to allow the workbook to be resized.)



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2000

Keywords: kbbug kbnofix KB231132

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.