I think your onto something Dave, I use John Walkenbach's menumaker code to
assign my macros to menu bar. As a test, I downloaded the current version
(menumakr.xls) and added a "HelloWorld" macro to the worksheet as well as
assigned it to the first menu item. After creating the menu and executing
the code I get the following err msg:

The macro 'menumakr.xls!HelloWorld' cannot be found.

This leads me to believe it has nothing to do with the xla but rather my
environment.

Question: Is there a PATH that Excel searches for macros that might be
messed up?

"Dave Peterson" wrote:

I bet that the menu item points a different workbook (or a workbook with the
same name, but in a different location).

Tools|Customize (just to see the dialog)
rightclick on that icon and see what macro (and where it lives) is assigned to
the button.

You may want to consider building that toolbar each time that the addin opens:

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)

If you want to learn about modifying the ribbon in xl2007, you can start at Ron
de Bruin's site:
http://www.rondebruin.nl
or
http://www.rondebruin.nl/ribbon.htm



Shaken wrote:

Excel 2003, XP and Vista

I've been releasing VBA code through Add-Ins for years... Then last week any
new macros added can not be found in the Addin: Err Msg: The macro
'Addinname.xla!HelloWorld' cannot be found.

The code executes inside of VB editor but can not be referenced outside of
the editor???

Simple test: 1.New workbook,VB editor - Create HelloWorld, Assign macro to a
Menu button, Create Add-in via SaveAs, Try to execute via the button.

Any ideas would be greatly appreciated.

--

Dave Peterson