buttons & macros

[Jock W]

How can I,
a) add a button to a worksheet, and
b) assign a macro to that button?

tia

 

[patrick]

Easiest us selet forms toolar. Select button. This opens up macro
window-record macro. You didn't specify what event you want the button to
accomplish.
Pat

 

[Jock W]

Thanks Pat, job done.
--
Jock Waddington

Easiest us selet forms toolar. Select button. This opens up macro
window-record macro. You didn't specify what event you want the button to
accomplish.
Pat

 

[cleve mc daniel]

I need the same answer, did you get one?

 

[Jock W]

Yes, here it is:
Easiest is select forms toolar. Select button. This opens up macro
window-record macro. You didn't specify what event you want the button to
accomplish.

I found it easier to record the macro first then add button and assign the
recorded macro.