Assigning a module to a button macro
 

How do I assign a procedure in module1 to a custom button?

Assigning a module to a button macro
 

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

"DMB" wrote:

How do I assign a procedure in module1 to a custom button?

Assigning a module to a button macro
 

ToolsCustomizeCommands.

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

On Wed, 18 Jan 2006 13:26:02 -0800, DMB wrote:

How do I assign a procedure in module1 to a custom button?