Thanks a lot. i will try it

But i thought a macro runned always within the same workbook, that's not
what should be?


"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