Macro and user created button Question?

[R Guzman]

Hello all. I wanted to ask about macros and buttons. By that I mean, I'm
creating a spread sheet that I want a user to click on button I created on
the spreadsheet, and trigger the macro.



Does anyone know how this can be done?



Thanks!

[Bob Phillips]

Create your macro.

On the worksheet, drag a button from the Forms toolbar onto the sheet. You
will be asked which macro to assign it to. Choose your new macro.

Done!

--

HTH

RP
(remove nothere from the email address if mailing direct)


"R Guzman" <ralphguzman@earthlink.net> wrote in message
news:5ByBe.10402$aY6.6366@newsread1.news.atl.earthlink.net...
> Hello all. I wanted to ask about macros and buttons. By that I mean, I'm
> creating a spread sheet that I want a user to click on button I created on
> the spreadsheet, and trigger the macro.
>
>
>
> Does anyone know how this can be done?
>
>
>
> Thanks!
>
>

[R Guzman]

Thanks so much! Worked like a charm.


"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:eLh9%23cKiFHA.576@tk2msftngp13.phx.gbl...
> Create your macro.
>
> On the worksheet, drag a button from the Forms toolbar onto the sheet. You
> will be asked which macro to assign it to. Choose your new macro.
>
> Done!
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "R Guzman" <ralphguzman@earthlink.net> wrote in message
> news:5ByBe.10402$aY6.6366@newsread1.news.atl.earthlink.net...
>> Hello all. I wanted to ask about macros and buttons. By that I mean, I'm
>> creating a spread sheet that I want a user to click on button I created
>> on
>> the spreadsheet, and trigger the macro.
>>
>>
>>
>> Does anyone know how this can be done?
>>
>>
>>
>> Thanks!
>>
>>
>
>

[rmriba]

Bon - I tried that method, but the button would stay only on the
workbook I put it on (duh!). I placed a button on a toolbar from the
Customize / Macros menu. Only problem is (I want the button to open a
file I use all the tim) the button has a stupid happy face. How can I
change the icon? TIA

Bob Phillips wrote:
> Create your macro.
>
> On the worksheet, drag a button from the Forms toolbar onto the sheet. You
> will be asked which macro to assign it to. Choose your new macro.
>
> Done!
>

[Dave Peterson]

Try this:
tools|customize (just to have that dialog in front of you)

Find your smiley face icon and right click on it.
You'll see an option to change button image.

"rmriba" wrote:
>
> Bon - I tried that method, but the button would stay only on the
> workbook I put it on (duh!). I placed a button on a toolbar from the
> Customize / Macros menu. Only problem is (I want the button to open a
> file I use all the tim) the button has a stupid happy face. How can I
> change the icon? TIA
>
> Bob Phillips wrote:
> > Create your macro.
> >
> > On the worksheet, drag a button from the Forms toolbar onto the sheet. You
> > will be asked which macro to assign it to. Choose your new macro.
> >
> > Done!
> >

--

Dave Peterson