"Dave Peterson" wrote:

You can turn off the tabs via:
tools|Options|View tab|uncheck Sheet tabs
(xl2003 menu system)

They can also be hidden by just not being on the window. But I bet the resizing
(tiled???) would have shown them to you.
(Window|Arrange|Tiled -- in xl2003)

That's it!!! [WHEW!] Resizing to full screen and they appeared again...
Very odd. Thanks.

Another way they can hide is if horizontal scroll bar is dragged too far to the
left (so it covers the sheet tabs).

You can click and hold (on the left of the scroll bar) and drag to the right or
you can use a line of code:

Hit alt-f11 (to get to the VBE
hit ctrl-g (to see the immediate window)
type this and hit enter:
ActiveWindow.TabRatio = 0.5

Then close the VBE and check in Excel to see if it worked.

Cairos wrote:

Sometimes the sheet tabs don't show. I've tried resizing the window, and
sometimes they are there, sometimes not. I was working on this workbook and
it had tabs. when I saved and reopened, the tab wasn't visible and I can't
go to other sheets in the workbook.

--

Dave Peterson