Consolidating buttons

[Guest]

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

 

[Michael Malinsky]

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

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.