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 ?

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 ?

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 ?

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 ?