Thread: Custom menu created in an xla macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Custom menu created in an xla macro
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


Reply With QuoteReply With Quote