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" <(E-Mail Removed)> wrote in message
news2EAA150-8F76-4E84-9038-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news2EAA150-8F76-4E84-9038-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
news:A90604CC-0EE9-4775-9D73-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news2EAA150-8F76-4E84-9038-(E-Mail Removed)...
>> > 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.
>> >>
>> >>
>>
>>
>>