Worksheet Tabs Missing!
 

It's an intermittent problem. Is there a way to bring back the sheet tabs (at
the bottom) when they vanish? Did I inadvertently change a setting?

Thanks!
--
John

Likely you did inadvertently change a setting. The setting is "per
workbook"; meaning if you change it, the setting stays with the workbook.
Just go to Tools--Options, View tab, and check Worksheet tabs.
************
Anne Troy
www.OfficeArticles.com

"Training Spec." wrote in message
...
It's an intermittent problem. Is there a way to bring back the sheet tabs
(at
the bottom) when they vanish? Did I inadvertently change a setting?

Thanks!
--
John

Worksheet Tabs Missing!
 

I had tried that solution, but it doesn't work - the sheet tabs are still
missing.
--
John


"Anne Troy" wrote:

Likely you did inadvertently change a setting. The setting is "per
workbook"; meaning if you change it, the setting stays with the workbook.
Just go to Tools--Options, View tab, and check Worksheet tabs.
************
Anne Troy
www.OfficeArticles.com

"Training Spec." wrote in message
...
It's an intermittent problem. Is there a way to bring back the sheet tabs
(at
the bottom) when they vanish? Did I inadvertently change a setting?

Thanks!
--
John

Worksheet Tabs Missing!
 

Maybe they're hidden.

Window|arrange|tiled
so you can see the whole window

Or maybe you have the scroll bar too far to the right and it's hiding the sheet
tabs. If that scroll bar is as wide as the window, then you can drag the left
hand side back toward the middle.

Grab it by the vertical bar directly to the left of the arrow pointing left and
drag to the center of the screen.

Or you can try this...
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 back to excel to see if it helped.

Training Spec. wrote:

It's an intermittent problem. Is there a way to bring back the sheet tabs (at
the bottom) when they vanish? Did I inadvertently change a setting?

Thanks!
--
John

--

Dave Peterson