How to create button and associate a macro with it.

  • Thread starter Thread starter Nils Titley
  • Start date Start date
N

Nils Titley

I have a marco that does what I need. Now, I want to be able to assoicate
the macro with a button that I can put on the menu bar so users can push the
button and by magic the report is completed.

How do I do this?

Thanks for your help.
 
BillE,

I actually have a "Excell 2003 Power Programing with VBA" book by J.
Walkenbach.

Basically, You right click on the menu area. When the window comes up pick
Customize at the bottom. In the Customize window, click on Commands. In the
Catagories window, scrool down until you find macros. Click on Macros.
Click on
Custom Button under Commands and drag it to the menu and place it where you
want it. It will be a smiley face. As long as the Customize window is open
you can right click on the smiley face button and do your thing. You can
change what it looks like and you assign your macro to the button.

Hope that helps. Let me know if you have another question but realize. I
just learned how to do it myself.
 
Thanks!

Nils Titley said:
BillE,

I actually have a "Excell 2003 Power Programing with VBA" book by J.
Walkenbach.

Basically, You right click on the menu area. When the window comes up
pick
Customize at the bottom. In the Customize window, click on Commands. In
the
Catagories window, scrool down until you find macros. Click on Macros.
Click on
Custom Button under Commands and drag it to the menu and place it where
you
want it. It will be a smiley face. As long as the Customize window is
open
you can right click on the smiley face button and do your thing. You can
change what it looks like and you assign your macro to the button.

Hope that helps. Let me know if you have another question but realize. I
just learned how to do it myself.
Click to expand...
 
Back
Top