Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing Assign Macro Command
A have the following problem. I made a macro in MS Word and then made the
Command Button to the Word page by Control Toolbox Toolbar. Having tried to assign the macro to the newly created button by right clicking and selecting Assign macro, I have found that this command is missing in menu. However, I noticed, there is a difference between creating button by Control Toolbox Toolbar or Form Toolbar in Excel - assigning macro command is possible only when button is made by Form Toolbar. But in Word, there is missing Button icon in Form Toolbar, so I can't create the button which can may have macro assigned. What am I doing wrong? It already drives me crazy! Many thanks to everyone for help in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing Assign Macro Command
Millan
Double-click the button and you can assign code to the buttons click event, like this Private Sub CommandButton1_Click() Application.Run "TestMacro" End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "Millan" wrote in message ... A have the following problem. I made a macro in MS Word and then made the Command Button to the Word page by Control Toolbox Toolbar. Having tried to assign the macro to the newly created button by right clicking and selecting Assign macro, I have found that this command is missing in menu. However, I noticed, there is a difference between creating button by Control Toolbox Toolbar or Form Toolbar in Excel - assigning macro command is possible only when button is made by Form Toolbar. But in Word, there is missing Button icon in Form Toolbar, so I can't create the button which can may have macro assigned. What am I doing wrong? It already drives me crazy! Many thanks to everyone for help in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Missing Assign Macro Command
You are doing nothing wrong. The Button on the Word Forms Toolbar is not
missing, it does not exist. Maybe you could find out what other Word users do by posting to a Word news group? Or just use the Button from the Control Toolbox as Nick suggests. Gord Dibben MS Excel MVP On Sun, 15 Oct 2006 12:34:01 -0700, Millan wrote: A have the following problem. I made a macro in MS Word and then made the Command Button to the Word page by Control Toolbox Toolbar. Having tried to assign the macro to the newly created button by right clicking and selecting Assign macro, I have found that this command is missing in menu. However, I noticed, there is a difference between creating button by Control Toolbox Toolbar or Form Toolbar in Excel - assigning macro command is possible only when button is made by Form Toolbar. But in Word, there is missing Button icon in Form Toolbar, so I can't create the button which can may have macro assigned. What am I doing wrong? It already drives me crazy! Many thanks to everyone for help in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign MAcro to command button | Excel Programming | |||
Assign a macro to a command button | Excel Discussion (Misc queries) | |||
Assign Macro to Command Button | Excel Programming | |||
Assign a macro to a command button | Excel Programming | |||
Assign to macro missing | Excel Discussion (Misc queries) |