Creating a button to execute a macro

[ZBelden]

Pretty basic, I just want to create a button that looks like a text box when
upon pushing it, the macro gets executed. I've been looking in help and an
excel book I have but haven't been able to find it... Any help is appretiated

Zach

 

[Gary''s Student]

View > Toolbars > Forms

click on the button icon and make the button
right-click on the button you just made and assign macro

 

[ZBelden]

Thanks

View > Toolbars > Forms

click on the button icon and make the button
right-click on the button you just made and assign macro

 

[GTVT06]

Thanks







- Show quoted text -

Go to:
Tools/Customize/Commands/Forms/Button
Drag it onto a tool tray and then click on the button Icon and create
your button on the spreadsheet and assign it a Macro.

 

[Gord Dibben]

Note:

You can assign a macro to any object like a picture, wordart object and many
more, but the easiest is the suggestion gary's student posted here.

I use a picture of my mother-in-law for a particularly destructive macro.


Gord Dibben MS Excel MVP