Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
toolbar buttons to allocate VBA macro
under Excel 2007,
is it possible to add custom buttons (smileys) to allocate macros as it could under Excel 2000 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
toolbar buttons to allocate VBA macro
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 Roland wrote: under Excel 2007, is it possible to add custom buttons (smileys) to allocate macros as it could under Excel 2000 ? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
toolbar buttons to allocate VBA macro
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. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Roland" wrote: under Excel 2007, is it possible to add custom buttons (smileys) to allocate macros as it could under Excel 2000 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customized Toolbar Macro Buttons | Setting up and Configuration of Excel | |||
Excel Toolbar Macro Buttons | Setting up and Configuration of Excel | |||
Buttons in a toolbar | Excel Discussion (Misc queries) | |||
Missing Macro Buttons on Toolbar | Excel Discussion (Misc queries) | |||
Reassigning macro locations for toolbar buttons | Excel Discussion (Misc queries) |