View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
pegman pegman is offline
external usenet poster
 
Posts: 17
Default sheet tabs disappeared


turns out that winow/arrange/windows of active workbook got unchecked...
checked it and it's all better, never would have seen it or thought of
looking there if not your input... just took a guess and it worked.

Thanks
"Dave Peterson" wrote:

How about
Window|Arrange|Tiled (and resize so that you can see everything)

Or maybe the horizontal scroll bar is too far to the right and is hiding the
tabs. You can adjust the width of that horizontal scroll bar by clicking and
dragging its edge.

Or you can
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

(It'll make the horizontal scrollbar and tabs use the same amount of space.)

Then alt-f11 to get back to excel.

pegman wrote:

tool/options/tabs checks out OK but the tabs don't show up ksld;fgas;d


--

Dave Peterson