ExcelBanter - How do I add a customized button with macro in Excel 2007 for acce

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - How do I add a customized button with macro in Excel 2007 for acce (https://www.excelbanter.com/setting-up-configuration-excel/202446-how-do-i-add-customized-button-macro-excel-2007-acce.html)

Lmm

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

Ron de Bruin

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

Lmm

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

All times are GMT +1. The time now is 05:46 PM.