Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Assign Macro To Form Or Control Button. No Assign Macro dialog pops up however and when you right click on the button the context menu has no Assign Macro element either. Assign a Macro to a Sharp 1Click the Shapes button under the Insert tab.
Assign a macro to the button. Click the Command Button button and drag a rectangle in the worksheet where you want the button. An ActiveX button always activates one and only one macro whose name is the button controls name with _Click tacked on the end.
Click the Command Button button and drag a rectangle in the worksheet where you want the button.
ActiveX controls work a bit differently. Then drag the mouse to draw a button on the active sheet and in the popped out Assign Macro dialog box click OK. Assign a macro to a form control button but only let the user press this button once. Click on the Developer tab In the Control group click on Insert.