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.

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

Thanks for looking!!!

"Nils Titley" wrote:

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.

can you share?
thanks!
Bill
"Nils Titley" wrote in message
...
Never mind, I found a place that tells me how to do it.

Thanks for looking!!!

"Nils Titley" wrote:

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.


"BillE" wrote:

can you share?
thanks!
Bill
"Nils Titley" wrote in message
...
Never mind, I found a place that tells me how to do it.

Thanks for looking!!!

"Nils Titley" wrote:

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.

Thanks!

"Nils Titley" wrote in message
...
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" wrote:

can you share?
thanks!
Bill
"Nils Titley" wrote in message
...
Never mind, I found a place that tells me how to do it.

Thanks for looking!!!

"Nils Titley" wrote:

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.