Excel 2007 custom macros/icons

[Tom Kreutz]

When I switched to Office 2007 and enabled the Developer ribbon in Word
2007, my custom VBA macros and icons(!) all showed up in a new Add-Ins
ribbon, in a section labeled "Toolbar Commands". Not so in Excel 2007,
where the Add-Ins ribbon is basically empty. Does anybody know why?
Did I do something wrong?

Thanks, Tom Kreutz

 

[Jim Rech]

If a workbook or add-in has toolbuttons attached to it or runs code that
creates toolbuttons they should appear on the Excel 2007 Add-in ribbon tab.

If you have toolbuttons that appear because they are part of you fixed Excel
toolbar set (saved in your Excel 2003 XLB file), you may have to open it
manually via File, Open. You should have to do this only once as they will
then become part of your Excel 2007 XLB file.

The Excel 2003 XLB file is usually found here:

C:\Documents and Settings\<user name>\Application
Data\Microsoft\Excel\Excel11.XLB

--
Jim
| When I switched to Office 2007 and enabled the Developer ribbon in Word
| 2007, my custom VBA macros and icons(!) all showed up in a new Add-Ins
| ribbon, in a section labeled "Toolbar Commands". Not so in Excel 2007,
| where the Add-Ins ribbon is basically empty. Does anybody know why?
| Did I do something wrong?
|
| Thanks, Tom Kreutz

 

[Tom Kreutz]

Dear Jim, Thanks very much for your note. Although I've created many
custom macros and icons, I've never made a custom toolbar or used an XLB
file. Your note led me into a whole new area of Excel. Many thanks! Tom