Assign Macro to command button

D

DavidC

Right click on the toolbar and select customise. Can get
to this with the "View" "Toolbar" "Customise...".

This brings up the customise box. Right click then on the
button you wish to assign a macro to. The menu then has a
place towards the bottom where the macro can be assigned.

Hope this is what you need.

BOL

DavidC
 
G

Gord Dibben

John

If button is from the Forms Toolbar, just right-click and "Assign macro"

If button from the Control Toolbox, right-click and "View Code"

Copy the macro in there or just reference the macro by name.

Gord Dibben Excel MVP
 
Top