| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbar width
I just loaded XL2003. I noticed that the toolbars are at least 2 controls
wide. Only docked tool bars are single contol wide. Can I change this somehow? I've tried doing it by VBA, but it didn't work. -- Thanks, Don |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Toolbar width
Maybe ToolsCustomizeOptions.............make sure Show Standard and Formatting
Toolbars on Two Rows is checked. Gord Dibben MS Excel MVP On Tue, 27 Nov 2007 15:21:02 -0800, DRA wrote: I just loaded XL2003. I noticed that the toolbars are at least 2 controls wide. Only docked tool bars are single contol wide. Can I change this somehow? I've tried doing it by VBA, but it didn't work. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Toolbar width
DRA
Just hover you curser over one end of the tool bar and drag it out, it will change to only a single row. If you push it in it will become a verticle column only one wide. Mike Rogers "DRA" wrote: I just loaded XL2003. I noticed that the toolbars are at least 2 controls wide. Only docked tool bars are single contol wide. Can I change this somehow? I've tried doing it by VBA, but it didn't work. -- Thanks, Don |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Toolbar width
I tried both of these, but neither worked.
Mike, I could get one row. but not one verticle column only one wide. -- Thanks, Don "DRA" wrote: I just loaded XL2003. I noticed that the toolbars are at least 2 controls wide. Only docked tool bars are single contol wide. Can I change this somehow? I've tried doing it by VBA, but it didn't work. -- Thanks, Don |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Toolbar width
DRA
Tell me which tool bar you are having troubles with, they all act the same when floating on the worksheet, but maybe I can figure something out. Mike Rogers "DRA" wrote: I tried both of these, but neither worked. Mike, I could get one row. but not one verticle column only one wide. -- Thanks, Don "DRA" wrote: I just loaded XL2003. I noticed that the toolbars are at least 2 controls wide. Only docked tool bars are single contol wide. Can I change this somehow? I've tried doing it by VBA, but it didn't work. -- Thanks, Don |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Toolbar width
DRA
Did a little research and they do not all act the same. Here is what I found when checking to see if the tool bar would, while floating (not docked) change from a single button wide (column) to a single button tall (row)[xl2k]: Tool Bar Row Column Clip board No No Pivot Table No No Chart Yes No Web Yes No Drawing Yes No Show Full Path Yes No Control Toolbox Yes Yes External Data Yes Yes Forms Yes Yes Picture Yes Yes Reviewing Yes Yes Visual Basic Yes Yes I hope this helps Mike Rogers "DRA" wrote: I tried both of these, but neither worked. Mike, I could get one row. but not one verticle column only one wide. -- Thanks, Don "DRA" wrote: I just loaded XL2003. I noticed that the toolbars are at least 2 controls wide. Only docked tool bars are single contol wide. Can I change this somehow? I've tried doing it by VBA, but it didn't work. -- Thanks, Don |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Toolbar width
Mike,
I tried to duplicate your resukts, but no go. There appears to be an extra item on the title bar for the toolbar with a "–¼", that when clicked, "Add or remove buttons". Guess, I'm stuck. -- Thanks for your help, Don "Mike Rogers" wrote: DRA Did a little research and they do not all act the same. Here is what I found when checking to see if the tool bar would, while floating (not docked) change from a single button wide (column) to a single button tall (row)[xl2k]: Tool Bar Row Column Clip board No No Pivot Table No No Chart Yes No Web Yes No Drawing Yes No Show Full Path Yes No Control Toolbox Yes Yes External Data Yes Yes Forms Yes Yes Picture Yes Yes Reviewing Yes Yes Visual Basic Yes Yes I hope this helps Mike Rogers "DRA" wrote: I tried both of these, but neither worked. Mike, I could get one row. but not one verticle column only one wide. -- Thanks, Don "DRA" wrote: I just loaded XL2003. I noticed that the toolbars are at least 2 controls wide. Only docked tool bars are single contol wide. Can I change this somehow? I've tried doing it by VBA, but it didn't work. -- Thanks, Don |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data-Validation-List-Width of list must be colomn width, is this possible | Excel Worksheet Functions | |||
| ASC() does not convert full-width to half-width letters (Exel 2003 | Excel Worksheet Functions | |||
| How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
| Adjusting toolbar size, restore toolbar | Excel Discussion (Misc queries) | |||
| How can I keep Toolbar Buttons on the toolbar? | Setting up and Configuration of Excel | |||
Linear Mode
