| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Applying a macro to a command button, Excel 2002
I have done this in 2003. Create a command button, macro list appears (or
right click and assign macro) In 2002 I dont see the same options. I was able to create a regular rectangle shape and apply the macro to that. Any thoughts? THanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Applying a macro to a command button, Excel 2002
There are two buttons that look alike.
One button is from the Forms toolbar that has the behavior you want and the other is a commandbutton from the Control toolbox toolbar (and it works works differently). I bet you used the one you didn't want. Remove the commandbutton and replace it with the button from the Forms toolbar. Vicky wrote: I have done this in 2003. Create a command button, macro list appears (or right click and assign macro) In 2002 I dont see the same options. I was able to create a regular rectangle shape and apply the macro to that. Any thoughts? THanks! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Applying a macro to a command button, Excel 2002
Errrr - Is this the same in 2003?
"Dave Peterson" wrote: There are two buttons that look alike. One button is from the Forms toolbar that has the behavior you want and the other is a commandbutton from the Control toolbox toolbar (and it works works differently). I bet you used the one you didn't want. Remove the commandbutton and replace it with the button from the Forms toolbar. Vicky wrote: I have done this in 2003. Create a command button, macro list appears (or right click and assign macro) In 2002 I dont see the same options. I was able to create a regular rectangle shape and apply the macro to that. Any thoughts? THanks! -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Applying a macro to a command button, Excel 2002
never mind
"Vicky" wrote: Errrr - Is this the same in 2003? "Dave Peterson" wrote: There are two buttons that look alike. One button is from the Forms toolbar that has the behavior you want and the other is a commandbutton from the Control toolbox toolbar (and it works works differently). I bet you used the one you didn't want. Remove the commandbutton and replace it with the button from the Forms toolbar. Vicky wrote: I have done this in 2003. Create a command button, macro list appears (or right click and assign macro) In 2002 I dont see the same options. I was able to create a regular rectangle shape and apply the macro to that. Any thoughts? THanks! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create a command button, then assign macro to it in excel | Excel Discussion (Misc queries) | |||
| how do you assign a macro to a command button in Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I assign a macro to a command button in excel, office 2003 | Excel Discussion (Misc queries) | |||
| How do i create a command button or macro to exit Microsoft Excel | Excel Worksheet Functions | |||
| excell 2002 dimmed command button | Excel Discussion (Misc queries) | |||
Linear Mode
