![]() |
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? |
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 |
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? |
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? |
All times are GMT +1. The time now is 12:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com