My sheet tabs disappeared. Options shows they are active.

C

Cairos

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.
 
D

Dave Peterson

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)

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.
 
S

Sandy Mann

When you got to Tools > Options > View is Sheet tabs checked? If not
check it and then see if you have sheet tabs

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
D

Devonshire

Dave Peterson said:
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)
Click to expand...

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