XL2003 toolbar macros in XL2007

[Paul Martin]

Hi guys

I have a number of macros from XL2003 that create custom toolbars at
startup. How do I make these useful/usable in XL2007?

I've used Windows Easy Transfer to get my Office and other settings
transferred from XP/Office2003 to Vista/Office2007 and mostly it's
worked. But my Excel settings, eg *.olb, startup files, etc, haven't
transferred across as far as I can tell. Can someone suggest a good
tutorial for this info?

Thanks in advance

Paul Martin
Melbourne, Australia

 

[Dave Peterson]

I create the toolbars in xl2003 in the code with the macros. When I use the
same file in xl2007, these toolbars appear under the Addins tab on the ribbon.

I didn't need to make any changes to the existing *.xla files (my macro files
are addins).

If you manually changed the toolbar, I'm not sure how to handle those changes in
xl2007. Maybe you can change your addins to do the same in code. Or make the
changes to the QAT.

And I put my personal.xla file into the XLStart folder (for xl2007) and had no
trouble seeing my toolbars in the addins tab of the ribbon.

======
(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