Creating a button to execute a macro
 

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

Creating a button to execute a macro
 

View Toolbars Forms

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


--
Gary''s Student - gsnu200767


"ZBelden" wrote:

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

Creating a button to execute a macro
 

Thanks

"Gary''s Student" wrote:

View Toolbars Forms

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


--
Gary''s Student - gsnu200767


"ZBelden" wrote:

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

Creating a button to execute a macro
 

On Feb 1, 2:08*pm, ZBelden wrote:
Thanks



"Gary''s Student" wrote:
View Toolbars Forms

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

--
Gary''s Student - gsnu200767

"ZBelden" wrote:

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- Hide quoted text -

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

Creating a button to execute a macro
 

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


On Fri, 1 Feb 2008 12:08:07 -0800, ZBelden
wrote:

Thanks

"Gary''s Student" wrote:

View Toolbars Forms

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


--
Gary''s Student - gsnu200767


"ZBelden" wrote:

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