How do I assign a procedure in module1 to a custom button?
J Jim May Jan 18, 2006 #2 The easiest way is in your workbook, to Click on the View Menu, then Toolbars __>> Forms; then Click and drag the command button from the palette off onto the Worksheet.. as you drop the button the Macro Box pops up, Select your Macro, and OK.. HTH
The easiest way is in your workbook, to Click on the View Menu, then Toolbars __>> Forms; then Click and drag the command button from the palette off onto the Worksheet.. as you drop the button the Macro Box pops up, Select your Macro, and OK.. HTH
G Gord Dibben Jan 19, 2006 #3 Tools>Customize>Commands. Scroll down to "Macros" and select. Drag the smiley-face button to your toolbar and right-click and "assign macro" You can also "change button image" or "edit button image" if you don't like the smiley. Gord Dibben MS Excel MVP
Tools>Customize>Commands. Scroll down to "Macros" and select. Drag the smiley-face button to your toolbar and right-click and "assign macro" You can also "change button image" or "edit button image" if you don't like the smiley. Gord Dibben MS Excel MVP
