buttons
how do I add a macro to a button? I am able to print a hole sheet from 1
button but I only want to print 1 page of the sheet not the whole and I can not add the macro to the button. how can I do this? Thanks |
buttons
Show the Forms toolbar
In xl2003 menus, View|Toolbars|check Forms Then click on the button and draw it where you want it. You'll be prompted to assign your macro to that button. If you choose to assign the macro later, you can rightclick on that button and select Assign Macro. The button from the Forms toolbar behaves differently from the commandbutton from the Control toolbox toolbar. Matt wrote: how do I add a macro to a button? I am able to print a hole sheet from 1 button but I only want to print 1 page of the sheet not the whole and I can not add the macro to the button. how can I do this? Thanks -- Dave Peterson |
buttons
I created my contraol button and when I right click I only get
cut copy paste Properites View code Command buttion Hpow do I get the assign macro button when I right click? "Dave Peterson" wrote: Show the Forms toolbar In xl2003 menus, View|Toolbars|check Forms Then click on the button and draw it where you want it. You'll be prompted to assign your macro to that button. If you choose to assign the macro later, you can rightclick on that button and select Assign Macro. The button from the Forms toolbar behaves differently from the commandbutton from the Control toolbox toolbar. Matt wrote: how do I add a macro to a button? I am able to print a hole sheet from 1 button but I only want to print 1 page of the sheet not the whole and I can not add the macro to the button. how can I do this? Thanks -- Dave Peterson |
buttons
You used a commandbutton from the control toolbox toolbar.
Delete that commandbutton. Show the Forms toolbar. Use the button from that forms toolbar. Matt wrote: I created my contraol button and when I right click I only get cut copy paste Properites View code Command buttion Hpow do I get the assign macro button when I right click? "Dave Peterson" wrote: Show the Forms toolbar In xl2003 menus, View|Toolbars|check Forms Then click on the button and draw it where you want it. You'll be prompted to assign your macro to that button. If you choose to assign the macro later, you can rightclick on that button and select Assign Macro. The button from the Forms toolbar behaves differently from the commandbutton from the Control toolbox toolbar. Matt wrote: how do I add a macro to a button? I am able to print a hole sheet from 1 button but I only want to print 1 page of the sheet not the whole and I can not add the macro to the button. how can I do this? Thanks -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 11:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com