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