Wierd Sheet Tabs Behavior

[jkend69315]

Excel 2002. My workbook has 37 worksheets. If I go to Tools>Options,
View Tab, and check Sheet Tabs, the tabs are shown only on the first 29
sheets. Has anyone else experienced this problem or have a clue as to
what's wrong? Thanks.

 

[RagDyeR]

Have you tried:
<Format> <Sheet> <Unhide>
?
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Excel 2002. My workbook has 37 worksheets. If I go to Tools>Options,
View Tab, and check Sheet Tabs, the tabs are shown only on the first 29
sheets. Has anyone else experienced this problem or have a clue as to
what's wrong? Thanks.

 

[jkend69315]

Thanks. But the sheets are showing fine. It's the sheet tabs that are
acting wierd.

 

[Niek Otten]

Did you click the little arrows to the left of the tabs?

--
Kind regards,

Niek Otten

| Thanks. But the sheets are showing fine. It's the sheet tabs that are
| acting wierd.
|

 

[jkend69315]

Thanks, Rag and Nick, for your replies. I'm guessing that my Show
Sheet Tabs is probably conflicting with Excel's Show Tabs on the Tools
menu and this is causing the problem. Compounding the issue, I
sometimes use Full Screen on some of the sheets and not on others.
Anyway, turning off sheet tabs in the Tools menu and closing and
reopening the file and then turning on Sheets Tabs in the Tools menu
restores the tabs. I think it's just one of those wierd things that
happens sometimes in Excel.
Regards,
James