Yes originally the macro was duplicated in several xls workbooks.
I wanted to rationalize by using an xla file instead
i kept "mymacro" (the name for the example) in the xls workbooks but
unactivated their menus.
The point is that if i delete the entire projects in theses xls worbooks,
the xla menu still points to them if they are the active workbooks, even
with
.OnAction = "'" & ThisWorkbook.Name & "'!mymacro"
(i thought ThisWorkbook.Name referred to the xla in which the menus are)
I did something else : i renamed mymacro in the xla workbooks and now it
works, as if even with deleted projects in xls workbooks, there was still
something left with the older code.
What is strange too is that other macros in theses xls workbooks also had
the same names as in the xla workbook and no problem with them
Hope my english is clear. I'm french ;-)
Thanks
"Gord Dibben" <gorddibbATshawDOTca> a écrit dans le message de groupe de
discussion : (e-mail address removed)...
I think you have confused Excel by having "mymacro" in two separate
workbooks.
Delete the "mymacro" from the workbook then save.
Close Excel then reopen with your saved workbook.
Where does the toolbar button point to?
Gord