Simple VBA Question....?????

[bfraser]

I have three macros that I want to run right after each other.
Does anyone know how I would do this and assign them to a single toolbar icon?

 

[capparfrank]

sub driver()
     Call macro1()
     Call macro2()
     Call macro3()
 
end sub

In excel 2007, you can hook driver() up to the Quick Access Toolbar under the Excel button, Excel Options, Customize.

under 'Choose commands from' combobox, pick Macros.
Add driver() (or whatever you name it)
change the icon if you want with the 'modify' button


In 2003, I can't quite remember. But I believe it's under Tools/options and there's a place you can hook up keyboard shortcuts or toolbar menu items. Sorry, i'm pretty foggy on that one these days.

 

[Michael M]

In 2003, right click in the grey area of the toolbar and select customize.
Select Commands / Macros in the left pane.
Drag a button from the right pane to your toolbar, now right click on it to modify and assign macros.

 

[bfraser]

Thank you to both of you.

I am starting with Excel 2003, so Michael how do I assign more than one macro so module to one toolbar icon. I only seem to be able to assign one?

 

[Michael M]

You can only assin one macro to each custom button, so...
Once you have followed my instruction in Post #3
You have a couple of choices.
1. Add more custom buttons and assisn macros to each one
2. Assign the driver() macro, mentioned by cappafrank to the button which calls the others
3. Rather than add custom buttons, add a custom menu instead and then add the custom buttons under that new menu.

 

[bfraser]

Thank you very much for all your help.