Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 xla Add In Macro convert to 2007?
Hi,
I've created several custom toolbars as an .xla add-in and distributed them to various people in my company. This appears to be one of the better methods for sharing macros (un excel 2003). We're planning to convert to 2007 and I'd like to know what will happen to these macros, what I may need to do to keep them working and if there is now a better way in 2007 to share custom macros. Thank you! Karin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 xla Add In Macro convert to 2007?
I have an add that was created in earlier versions of excel (before the
ribbon). My addin creates the toolbar when it opens and destroys it when it closes. In xl2007, the toolbar shows up in the Addins tab of the ribbon. How did you create the toolbar? Via code or manually? Saved from a previous post: For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) In xl2007, those toolbars and menu modifications will show up under the addins. And if you use xl2007: 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 Karin wrote: Hi, I've created several custom toolbars as an .xla add-in and distributed them to various people in my company. This appears to be one of the better methods for sharing macros (un excel 2003). We're planning to convert to 2007 and I'd like to know what will happen to these macros, what I may need to do to keep them working and if there is now a better way in 2007 to share custom macros. Thank you! Karin -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 xla Add In Macro convert to 2007?
Hi, Dave -- I used your code from the Contextures web site to build my
toolbar - and thank you very much for that, it's a wonderful tool! Thank you for the response, I will review everything you recommend. "Dave Peterson" wrote: I have an add that was created in earlier versions of excel (before the ribbon). My addin creates the toolbar when it opens and destroys it when it closes. In xl2007, the toolbar shows up in the Addins tab of the ribbon. How did you create the toolbar? Via code or manually? Saved from a previous post: For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) In xl2007, those toolbars and menu modifications will show up under the addins. And if you use xl2007: 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 Karin wrote: Hi, I've created several custom toolbars as an .xla add-in and distributed them to various people in my company. This appears to be one of the better methods for sharing macros (un excel 2003). We're planning to convert to 2007 and I'd like to know what will happen to these macros, what I may need to do to keep them working and if there is now a better way in 2007 to share custom macros. Thank you! Karin -- Dave Peterson . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003 xla Add In Macro convert to 2007?
I've seen other people recommend this, too:
http://www.datapigtechnologies.com/freeware.htm From Mike Alexander I haven't used it, though. (I still spend 95% of my time in xl2003, so I can live with the toolbar in the Addins tab.) Karin wrote: Hi, Dave -- I used your code from the Contextures web site to build my toolbar - and thank you very much for that, it's a wonderful tool! Thank you for the response, I will review everything you recommend. "Dave Peterson" wrote: I have an add that was created in earlier versions of excel (before the ribbon). My addin creates the toolbar when it opens and destroys it when it closes. In xl2007, the toolbar shows up in the Addins tab of the ribbon. How did you create the toolbar? Via code or manually? Saved from a previous post: For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) In xl2007, those toolbars and menu modifications will show up under the addins. And if you use xl2007: 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 Karin wrote: Hi, I've created several custom toolbars as an .xla add-in and distributed them to various people in my company. This appears to be one of the better methods for sharing macros (un excel 2003). We're planning to convert to 2007 and I'd like to know what will happen to these macros, what I may need to do to keep them working and if there is now a better way in 2007 to share custom macros. Thank you! Karin -- Dave Peterson . -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONVERT FILES FROM EXCEL 2003 TO 2007 | Excel Discussion (Misc queries) | |||
Convert SUMIFS formula from 2007 to 2003 | Excel Discussion (Misc queries) | |||
Trying to convert a excel 2003 to 2007, but it contain script. | Excel Discussion (Misc queries) | |||
2003--2007 convert problems | Excel Discussion (Misc queries) | |||
Can you convert this formula to 2003 from 2007? | Excel Worksheet Functions |