How to create button and associate a macro with it.

[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.

 

[Nils Titley]

Never mind, I found a place that tells me how to do it.

Thanks for looking!!!

 

[BillE]

can you share?
thanks!
Bill

Never mind, I found a place that tells me how to do it.

Thanks for looking!!!

 

[Nils Titley]

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.

 

[BillE]

Thanks!

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.