ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Insert macro in a toolbar menu (https://www.excelbanter.com/excel-programming/435234-insert-macro-toolbar-menu.html)

Roughar

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?

Dave Peterson

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

Bob Phillips[_3_]

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?




Patrick Molloy[_2_]

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