Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 custom macros/icons
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 custom macros/icons
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 he C:\Documents and Settings\<user name\Application Data\Microsoft\Excel\Excel11.XLB -- Jim "Tom Kreutz" wrote in message ... | 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 custom macros/icons
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 Jim Rech wrote: 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 he C:\Documents and Settings\<user name\Application Data\Microsoft\Excel\Excel11.XLB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
large icons in the Excel 2007 ribbon? | Excel Discussion (Misc queries) | |||
What causes custom icons in the excel standard toolbar | Excel Discussion (Misc queries) | |||
Excel 2007 Toolbar Icons | Setting up and Configuration of Excel | |||
Icons in Excel 2007 | New Users to Excel | |||
How do I add icons to the ribbon boxes in excel 2007 | Excel Discussion (Misc queries) |