| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Command Button / Macro won't execute properly | Excel Programming | |||
| Execute Macro When any Built-in Autofilter Button is Pushed | Excel Programming | |||
| Macro won't execute from a Command Button | Excel Programming | |||
| Creating command buttons beside every row to execute each row macro | Excel Programming | |||
| button to execute macro | Excel Programming | |||
Linear Mode
