| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I add a customized button with macro in Excel 2007 for acce
I have macro to run PasteSpecial with pasting values only. In Excel 2003,
it's launched by clicking a toolbar button. Now upgrade to Excel 2007 though I can customized quick access bar, but how do I associate the macro with a button or something and add that button to quick access bar or some customized ribbon for easy acces? Thanks. Lmm |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
How do I add a customized button with macro in Excel 2007 for acce
Hi Lmm
Why not do this Click on the paste button on the home tab Right click on Paste Values in the menu list and choose Add to QAT bar If you want it easy menu http://www.rondebruin.nl/qat.htm If you want to add a button to the ribbon follow the steps here http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Lmm" wrote in message ... I have macro to run PasteSpecial with pasting values only. In Excel 2003, it's launched by clicking a toolbar button. Now upgrade to Excel 2007 though I can customized quick access bar, but how do I associate the macro with a button or something and add that button to quick access bar or some customized ribbon for easy acces? Thanks. Lmm |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
How do I add a customized button with macro in Excel 2007 for
Cool, Ron, this is truly awsome... I know this is so easy for you but so
valuable for not excel expert... thanks! "Ron de Bruin" wrote: Hi Lmm Why not do this Click on the paste button on the home tab Right click on Paste Values in the menu list and choose Add to QAT bar If you want it easy menu http://www.rondebruin.nl/qat.htm If you want to add a button to the ribbon follow the steps here http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Lmm" wrote in message ... I have macro to run PasteSpecial with pasting values only. In Excel 2003, it's launched by clicking a toolbar button. Now upgrade to Excel 2007 though I can customized quick access bar, but how do I associate the macro with a button or something and add that button to quick access bar or some customized ribbon for easy acces? Thanks. Lmm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Record Macro button in Developer tab is not highlighted | Excel Discussion (Misc queries) | |||
| Excel 2007 crash when trying to add macro button to QAT | Excel Discussion (Misc queries) | |||
| Customized Macro Button Check | Excel Discussion (Misc queries) | |||
| How do I create a customized toolbar button? Excell 2007 | Excel Discussion (Misc queries) | |||
| How can I edit my macro button images in Excel 2007. | Excel Discussion (Misc queries) | |||
Linear Mode
