Excel 2000 worksheet tabs won't appear

[w8n]

I have an Excel 2000 workbook with several worksheets that has "given up" showing the worksheet tabs at the bottom of the window. I have tried setting/resetting Tools, Options, ViewTabs, SheetTabs, resizing the workbook window and the Excel window, turning off the taskbar, and rebooting to reload everything cleanly.
Other existing workbooks and new workbooks have no problems with the worksheet tabs, and Tools, Options... works fine on them.


All help is appreciated in advance!

Bob

 

[dcompto]

Tools > Options
View tab
Sheet tabs
OK

 

[Molby]

The sheets could of been hidden by code. If they are set to VeryHidden, they wont display regardless of what you do in the workbook. You would need to unhide them by code, run the below to see if that helps.

For Each sh In Sheets
 sh.Visible = True
Next sh

 

[dcompto]

w8n,
Sorry, I obviously didn't properly read your post!

 

[KenWright]

Has the horizontal scrollbar by any chance been resized to cover the tabs. Try dragging it back to the right.

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[w8n]

My thanks to everyone that replied...
FINALLY got the tabs, etc. to come back by:
Alt-Spacebar, Close w/ X
Alt-Hyphen, Close w/ X
Apparently the sizing "burped" and it took "manual" resizing to get it to clear up.
Dropped this note in case anyone else has this type of trouble.

Thanks again!
Bob