Assign Macro to Button

[jkgreen]

I have recorded a macro and put a button on my spreadsheet. Now how do I link the two?

Thanks,
Jason

 

[Gerald Higgins]

Right click on the button, then Assign Macro

 

[jkgreen]

Assign Macro does not appear on the menu when I right-click.

 

[Gerald Higgins]

Well then I don't know how to help, because it does appear on my pc.

 

[jkgreen]

The button I created is on the spreadsheet itself and not in a toolbar. I don't know if that will make a difference.

 

[carsten]

Try to take the button from Forms not a CommandButton from Control Toolbox ...

 

[lenze]

If your button is from the Forms Toolbar, it should give you the option to "Assign Macro" If it from the Control ToolBar, you will need to access "View Code"

lenze

 

[jkgreen]

I was able to copy the macro code from the editor and paste it in the button View Code editor.

Thanks for the input.

 

[seekeagle]

The control and forms controls can be confusing. Try this: (1) place a simple object on the spreadsheet with the drawing tool. (2) type the button name the drawing object. (3) try right clicking on the object to get the window that has an option "Assign macro". good luck.