| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 -- Assign a macro to a button
How can I assign a macro to a button?
Can I create a new button and put it on the Quick Toolbar? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 -- Assign a macro to a button
Yes this is possible
Right click on the QAT and choose "Customize Quick Access Toolbar". In the €śChoose commands from€ť dropdown choose "Macro's" But we have a problem now if you add the button only to your active workbook In the €śCustomize Quick Access Toolbar€ť dropdown choose €śFor <workbook name€ť. See this page then http://www.rondebruin.nl/qatbuttonbug.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Steve" wrote in message ... How can I assign a macro to a button? Can I create a new button and put it on the Quick Toolbar? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 - assign macro to custom toolbar button | Excel Discussion (Misc queries) | |||
| How can I assign button/buttons to XL 2007 by Macro for different | Excel Worksheet Functions | |||
| how to create a command button, then assign macro to it in excel | Excel Discussion (Misc queries) | |||
| how do you assign a macro to a command button in Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I assign a macro to a command button in excel, office 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
