Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert macro in a toolbar menu
Hy, i´ve created a macro and salve it in a xlstart folder. using excel 2003,
i could insert it in a toolbar menu. how do i do to insert it using excel 2007? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert macro in a toolbar menu
I mainly use xl2003. I build my toolbars on the fly when my addin opens.
When I open that addin in xl2007, the toolbars appear on the Addins tab in xl2007. If you don't think that is sufficient, then it's time to start learning about that ribbon. 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 Roughar wrote: Hy, i´ve created a macro and salve it in a xlstart folder. using excel 2003, i could insert it in a toolbar menu. how do i do to insert it using excel 2007? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert macro in a toolbar menu
In 2007 it will still be in a toolbar, it is just that the toolbar is in the
Addins tab. If you want it elsewhere, you will need to create some XML and add that to the file. -- __________________________________ HTH Bob "Roughar" wrote in message ... Hy, i´ve created a macro and salve it in a xlstart folder. using excel 2003, i could insert it in a toolbar menu. how do i do to insert it using excel 2007? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert macro in a toolbar menu
Ron de Bruin has some excellent code samples
http://www.rondebruin.nl/qat.htm "Roughar" wrote: Hy, i´ve created a macro and salve it in a xlstart folder. using excel 2003, i could insert it in a toolbar menu. how do i do to insert it using excel 2007? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot insert worksheet in exel - not available in insert menu | Excel Worksheet Functions | |||
Macro attached to New Menu item on toolbar | Excel Programming | |||
Macro behind Toolbar Menu Selection | Excel Programming | |||
Toolbar/Menu Bar | Excel Discussion (Misc queries) | |||
workbook-specfic Macro Menu in toolbar | Excel Programming |