Unfortunately i tried it today at the office and it does not work

mymacro is in the xla file and the menu command makes it works

if i open an xls workbook containing a copy of mymacro and then the menu
command makes that copy work. If i deleted that copy, a message says it
does not find 'mymacro'


"Ron de Bruin" a écrit dans le message de groupe
de discussion : ...
Try this Thomas

..OnAction = ThisWorkbook.Name & "!mymacro"

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"thomas" <nomail wrote in message
...
Hello,

I created a custom menu with a vba macro in an xla file (excel 2003) but
i
have a problem : When the code runs, it looks for the macro "mymacro"
defined in ".OnAction="mymacro" not in the xla file itself but in the
active
xls workbook.

I do not understand why

Thanks for your help