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

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

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

On Feb 1, 2:08*pm, ZBelden <ZBel...@discussions.microsoft.com> 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.

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 <(E-Mail Removed)>
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