| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Imbedded button to run macro
I run XL2003
I have designed a button embedded in my worksheet. I want my new button to run a macro which I recorded. How do I assign a specific macro to a specific button? I don't want to customize a button on a menu? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Imbedded button to run macro
Fritz
If you use a Button from the "Forms" toolbar, it asks you what macro to assign as soon as you have made the button. Mike Rogers -- The only dumb question is the one you did not ask. "Fritz" wrote: I run XL2003 I have designed a button embedded in my worksheet. I want my new button to run a macro which I recorded. How do I assign a specific macro to a specific button? I don't want to customize a button on a menu? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Imbedded button to run macro
Daaaa - thanks Mike - what a simple solution. I was trying to do it with a
button from the "control tool box menu". Thanks muchly - off an running "Mike Rogers" wrote: Fritz If you use a Button from the "Forms" toolbar, it asks you what macro to assign as soon as you have made the button. Mike Rogers -- The only dumb question is the one you did not ask. "Fritz" wrote: I run XL2003 I have designed a button embedded in my worksheet. I want my new button to run a macro which I recorded. How do I assign a specific macro to a specific button? I don't want to customize a button on a menu? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Imbedded button to run macro
Fritz
You can do it with a control tool box button but it is more involved. It also has its benifits thought. Good luck. You are welcome, Thanks for posting back Mike Rogers -- The only dumb question is the one you did not ask. "Fritz" wrote: Daaaa - thanks Mike - what a simple solution. I was trying to do it with a button from the "control tool box menu". Thanks muchly - off an running "Mike Rogers" wrote: Fritz If you use a Button from the "Forms" toolbar, it asks you what macro to assign as soon as you have made the button. Mike Rogers -- The only dumb question is the one you did not ask. "Fritz" wrote: I run XL2003 I have designed a button embedded in my worksheet. I want my new button to run a macro which I recorded. How do I assign a specific macro to a specific button? I don't want to customize a button on a menu? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PLS HELP! Excel imbedded object in Word | Excel Discussion (Misc queries) | |||
| Sorting data with an imbedded list | Excel Discussion (Misc queries) | |||
| How do I insert OR in imbedded formulas? | Excel Worksheet Functions | |||
| imbedded if statements | Excel Worksheet Functions | |||
| Stripping out imbedded spaces in a cell/row | Excel Worksheet Functions | |||
Linear Mode
