Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning a macro to a button
in Excel XP, I want to assign a macro to a button instead of using
Ctrl+something. Is this possible ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning a macro to a button
I have Excel 2000 (should be similar to XP). If you already have a macro
created, then you create the button, and it will prompt you for a macro to assign to it. Or you can right click on the button, and select assign macro. "Junkyard Engineer" wrote in message ... in Excel XP, I want to assign a macro to a button instead of using Ctrl+something. Is this possible ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning a macro to a button
for a button from the forms toolbar, right click on the button and select
assign macro. for a button from the control toolbox toolbar, double click on it while in design mode and put a call to your code it in the click event. -- Regards, Tom Ogilvy "Junkyard Engineer" wrote in message ... in Excel XP, I want to assign a macro to a button instead of using Ctrl+something. Is this possible ? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning a macro to a button
Ok thanks Tom & Brian :)
"Tom Ogilvy" a écrit dans le message de ... for a button from the forms toolbar, right click on the button and select assign macro. for a button from the control toolbox toolbar, double click on it while in design mode and put a call to your code it in the click event. -- Regards, Tom Ogilvy "Junkyard Engineer" wrote in message ... in Excel XP, I want to assign a macro to a button instead of using Ctrl+something. Is this possible ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning A Macro to A Button | Excel Worksheet Functions | |||
assigning a macro to a button | Excel Discussion (Misc queries) | |||
assigning macro to button | Excel Discussion (Misc queries) | |||
Assigning macro to button | Excel Discussion (Misc queries) | |||
Assigning a macro to a "button" | Excel Discussion (Misc queries) |