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

tia
--
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

"Jock W" wrote:

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

tia
--
Jock Waddington

Thanks Pat, job done.
--
Jock Waddington


"patrick" wrote:

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" wrote:

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

tia
--
Jock Waddington

I need the same answer, did you get one?

"Jock W" wrote:

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

tia
--
Jock Waddington

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.

--
Jock Waddington


"cleve mc daniel" wrote:

I need the same answer, did you get one?

"Jock W" wrote:

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

tia
--
Jock Waddington