Assign Macro to Button

[sswcharlie]

Hi

Excel 2000 Win7


I have done actions as per instructions on this site. Put Button into the Toolbox menu.

However when I use it opens ok, but the 'Assign Macro' message does not show up. I then have to cut and paste the code.

How do I get the 'Assign Macro' to appear ?

Thanks

Charlie

 

[Smitty]

Welcome to the Board!

It sounds like you may have use an ActiveX control, which requires direct coding, instead of a Forms control.

If you see: Private Sub CommandButton1_Click() you'll know for sure. But you can just call the code from there if you want:

 Private Sub CommandButton1_Click() 
  macro1
End Sub

Or try redrawing the button from the Form Toobox and you should get the Assign Macro dialog.

HTH,

 

[sswcharlie]

Hi Smitty


That sounds good advice. I will follow thru.

Thanks for instant service.

Regards

Charlie

 

[sswcharlie]

Hi Smitty

All sorted and working fine. Have the Assign Macro box appearing.

Thanks

Charlie