If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Consolidating buttons
I have a ridiculous amount of buttons that initiate macros on my worksheets. Is there a drop down menu option to consolidate or group certain buttons to make more room and less button clutter?
Secondly, if I put my macro buttons on the toolbar, will that diminish the amount of time it takes to save my workbooks? Currently an 800 kb file takes almost 10 seconds to save. Your help is greatly appreciated. David |
#2
|
|||
|
|||
Consolidating buttons
You can create a new menu item and assign your macros to different items in
that menu or create submenus to group your macros by type. Right click on a toolbar and select Customize. Under the Commands tab, select New Menu under the Categories box then drag the New Menu item to the menu bar. You can then select Macros under the Categories menu and drag Custom Menu Items to your new menu item. You can then change properties, assign macros, etc., by right-clicking on a particular item and making the appropriate selection from the popup menu. I don't know if you'll save any time, but you will surely gain screen space! HTH -- Michael J. Malinsky Pittsburgh, PA "I am a bear of very little brain, and long words bother me." -- AA Milne, Winnie the Pooh "David P." wrote in message ... I have a ridiculous amount of buttons that initiate macros on my worksheets. Is there a drop down menu option to consolidate or group certain buttons to make more room and less button clutter? Secondly, if I put my macro buttons on the toolbar, will that diminish the amount of time it takes to save my workbooks? Currently an 800 kb file takes almost 10 seconds to save. Your help is greatly appreciated. David |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using Multiple sets of Option buttons in one document | Keith Midgette | Mailmerge | 2 | June 11th, 2004 04:44 PM |
Moving buttons on a chart | Mark | Charts and Charting | 1 | May 26th, 2004 04:24 PM |
Radio Option Buttons Troubleshooting | Ellen W | Worksheet Functions | 1 | January 21st, 2004 06:26 PM |
Combo box instead of command buttons | John | Worksheet Functions | 9 | November 19th, 2003 04:26 PM |