Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign Macron to Button
Hi I have recorded a macro to Print the "print area" and made a button on a
sheet. macro is working properly when I run it. How can I assign to the button. I could not see anywhere where it says "Assign Macro" Even in Microsoft help it mentioned that Be in a design mode and right click on the button and select Assign Macro. I tried but no luck :( any idea please. winxp SP2/Office 2003 Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign Macron to Button
Hi MahaRaj
You are using a button from the Control Toolbox, this button have a click event. On a button from the Forms Toolbar you can right click and assign a macro Press the first button on the control toolbox to go into the design mode Double click on the button you placed on your worksheet. The VBA editor will open with this Private Sub CommandButton1_Click() End Sub You can place the code in the event or place the macroname in the event. Press Alt-q to go back to Excel and press the first button on the control toolbox again to exit the design mode -- Regards Ron de Bruin http://www.rondebruin.nl "MahaRaj®" wrote in message ... Hi I have recorded a macro to Print the "print area" and made a button on a sheet. macro is working properly when I run it. How can I assign to the button. I could not see anywhere where it says "Assign Macro" Even in Microsoft help it mentioned that Be in a design mode and right click on the button and select Assign Macro. I tried but no luck :( any idea please. winxp SP2/Office 2003 Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign Macron to Button
Thanks RON
you were right I made button from Toolbox. But I did not know about FORM. Thanks. it sorted now. I am gonna play with it now. Maha "Ron de Bruin" wrote in message ... Hi MahaRaj You are using a button from the Control Toolbox, this button have a click event. On a button from the Forms Toolbar you can right click and assign a macro Press the first button on the control toolbox to go into the design mode Double click on the button you placed on your worksheet. The VBA editor will open with this Private Sub CommandButton1_Click() End Sub You can place the code in the event or place the macroname in the event. Press Alt-q to go back to Excel and press the first button on the control toolbox again to exit the design mode -- Regards Ron de Bruin http://www.rondebruin.nl "MahaRaj®" wrote in message ... Hi I have recorded a macro to Print the "print area" and made a button on a sheet. macro is working properly when I run it. How can I assign to the button. I could not see anywhere where it says "Assign Macro" Even in Microsoft help it mentioned that Be in a design mode and right click on the button and select Assign Macro. I tried but no luck :( any idea please. winxp SP2/Office 2003 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I assign a symbol to a button (like the $ button) | Excel Discussion (Misc queries) | |||
Assign auto_open to a button | Excel Discussion (Misc queries) | |||
Assign Sub to Custom Button | Excel Programming | |||
Assign macro to button | Excel Programming | |||
Assign macro to button | Excel Programming |