| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Widen Sheet Tab View Q
What code could be used to widen the bottom task bar to fit/make
visible all sheets? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Widen Sheet Tab View Q
Don't know if there is a way to expand/contract the scrollbar size
automatically but.............. ActiveWindow.TabRatio = x With ratio being 0 (no sheets showing) to 1 (full width) ActiveWindow.TabRatio = .5 will be half the width. Note: if too many sheets not all will show in any case. Gord Dibben MS Excel MVP On Tue, 4 Aug 2009 06:11:45 -0700 (PDT), Seanie wrote: What code could be used to widen the bottom task bar to fit/make visible all sheets? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Widen name box | Excel Discussion (Misc queries) | |||
| view different parts of sheet - split view | Excel Discussion (Misc queries) | |||
| widen a drop down box | Excel Discussion (Misc queries) | |||
| View Custom View with Sheet Protection | New Users to Excel | |||
| widen the spreadsheet | Excel Discussion (Misc queries) | |||
Linear Mode
