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.
LVL 2
CompTech810Asked:
Who is Participating?
 
Chris BottomleyConnect With a Mentor Software Quality Lead EngineerCommented:
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
 
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 BottomleySoftware Quality Lead EngineerCommented:
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
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
SteveCommented:
Bah, put HML where I should have put XML.
0
 
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 BottomleySoftware Quality Lead EngineerCommented:
template file somewhere?
0
 
CompTech810Author Commented:
Not sure what you mean by 'template file somewhere'.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.