Assigning Macros to Buttons in Excel
 

I am trying to assign a macro to a button, however, after placing the button
on the worksheet, the "Assign Macro" window is not coming up. Is there
another way to assign the macro to the button?
--
Ronnie

Try right clicking on the button and lok for assign macro in the options.

"Ronnie" wrote:

I am trying to assign a macro to a button, however, after placing the button
on the worksheet, the "Assign Macro" window is not coming up. Is there
another way to assign the macro to the button?
--
Ronnie

Actually, I found it. I was using the "Control Toolbox" rather than the
"Forms" toolbar to insert my button. It makes a difference!
--
Ronnie


"bj" wrote:

Try right clicking on the button and lok for assign macro in the options.

"Ronnie" wrote:

I am trying to assign a macro to a button, however, after placing the button
on the worksheet, the "Assign Macro" window is not coming up. Is there
another way to assign the macro to the button?
--
Ronnie