• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 941
  • Last Modified:

Excel 2007 Change Add-In Macro Buttons

Hi Experts.  I have an Excel 2003 workbook that has macro buttons in the bottom toolbar.  Excel 2007 has put them in an Add-In tab on the ribbon.  

How do you edit the macro button that is on the Add-In tab.  For some reason a couple buttons have the wrong macro name.
0
CompTech810
Asked:
CompTech810
  • 3
  • 2
  • 2
1 Solution
 
SteveCommented:
To edit the Macro buttons in the addin tab...

[Alt]+ [F11]  to open the VBA editor.
Find the module which coresponds to the addin and in there somewhere will be the code for the addin.
If not password protected.
Feel free to post the addin here if you like.

To add the buttons to the ribbon on their own tab requires HML.
There are experts here who are more than capable of that, but I would focus on getting the addin working first.
0
 
Chris BottomleyCommented:
Office 2007 introduced the ribbon and older command bar based user menus devolved to the add ins tab of the ribbon.

It is a different approach for ribbon programming to introduce the buttons themselves into the files XML, and then add or call the active code which will reside in a normal VBA code module.  Note the XML and code can be in a dotm so that it can all work much the same as your existing ... Just XML for the menus etc.

Chris
0
 
SteveCommented:
Bah, put HML where I should have put XML.
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
CompTech810Author Commented:
I clicked on the Add-Ins tab(where the macro buttons are) and pressed [ALT]+[F11] and it brings up a blank Microsoft Visual Basic screen.
0
 
Chris BottomleyCommented:
template file somewhere?
0
 
CompTech810Author Commented:
Not sure what you mean by 'template file somewhere'.
0
 
Chris BottomleyCommented:
For example the macro which raises the menu item may have been put into normal.dotm or some other template.  Similarly they may exist in a file that you have opened and made permamanent and thererfre remain on view but without the linked macros to do anyhing useful.

Essentially though you need to look to putting the functions you want into your own file as XML and work the ribbon which is more future proof.

Chris
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now