toolbar buttons to allocate VBA macro

[Roland]

under Excel 2007,
is it possible to add custom buttons (smileys) to allocate macros as it
could under Excel 2000 ?

 

[Dave Peterson]

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

 

[Shane Devenshire]

Hi,

Yes. First create the macro. Then choose Office Button, Excel Options,
Customize, and from the first drop down at the top (Choose commands from)
pick Macros. Locate your macros and move it to the right by double-click it.
Then select it on the right and click Modify.