Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning a module to a button macro
How do I assign a procedure in module1 to a custom button?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a command button, then assign macro to it in excel | Excel Discussion (Misc queries) | |||
How do I Assign Macro to a button? | Charts and Charting in Excel | |||
delete a macro button is grayed out. | Excel Worksheet Functions | |||
Assigning a macro to a "button" | Excel Discussion (Misc queries) | |||
2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions |