disappearing tab

[missionarytrader]

One of my spreadsheet files has 5 worksheets. When I
enter one of them, all the worksheet tabs at the bottom
left of the screen disappear. This only happens in one of
the worksheets - the others work fine. The only way I am
able to get them back is to use the "go to" function to
another worksheet. The worksheets which work ok contain
all the tabs, but the one with probs, contains no
worksheet tabs.

Is there any way to unhide the tab, or do I have a corrupt
file???

 

[Myrna Larson]

Tools/Options/View and click the Sheet Tabs box near the bottom.

 

[missionarytrader]

thanks --- that works for 4 of the 5 worksheets, but not
the one in question. it remains tabless

 

[Gord Dibben]

Hit ALT + F11 to go to Visual Basic Editor.

Hit CRTL + R to open the Project Explorer.

Select your workbook/project.

Expand Microsoft Excel Objects.

Find the offending sheet and double-click to open.

Do you see any code that looks similar to this?

Private Sub Worksheet_Activate()
With ActiveWindow
.DisplayWorkbookTabs = False
End With
End Sub

Delete the code or just REM (') out the line.

Gord Dibben Excel MVP

 

[Gord Dibben]

Hit ALT + F11 to get to Visual Basic Editor.

Hit

Find the offending sheet under


See anything that looks like this?

Private Sub Worksheet_Activate()
With ActiveWindow
.DisplayWorkbookTabs = Not .DisplayWorkbookTabs
End With
End Sub

 

[Dave Peterson]

Are you sure that they're not hidden (after you tried Myrna's suggestion)?

There are VCR like controls to the left of the worksheet tabs. Use that to
scroll right left in the worksheet tabs.

(any chance that the scroll bar for the worksheet covers the other tab?)

And finally, is that worksheet tab portion just off the screen--

Window|arrange|tiled
and resize manually.