Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default sheet tabs disappeared

tool/options/tabs checks out OK but the tabs don't show up ksld;fgas;d
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default sheet tabs disappeared

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
  #3   Report Post  
Posted to microsoft.public.excel.misc
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
tabs are missing even though 'tools-options-view-sheet tabs' ok? rgranell Excel Worksheet Functions 3 August 16th 08 04:25 PM
My sheet tabs disappeared. Options shows they are active. Cairos Excel Discussion (Misc queries) 5 March 18th 08 07:35 AM
Sheet tabs & horizontal scrollbar disappeared - Excel 2003 RHK Excel Discussion (Misc queries) 3 November 29th 07 11:08 PM
The sheet tabs at the bottom of my worksheet has disappeared? tresses8m New Users to Excel 4 June 5th 07 11:04 PM
My sheet tabs disappeared with entered data. Can it be restored? Irene V in NJ Excel Discussion (Misc queries) 8 September 12th 06 05:43 PM


All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"