EXcel VBA - OnAction menu item property

[levelyn]

I know this should be simple, but I just can’t get it together.

I created a Macro/program as “Module1” in the modules folder o
VBProject MtxBr(MtxBrTcc1.xls). It is stored in the workbook
“MtxBrTcc1.xls”, and contains a procedure entitled “Sub MtxBrTcc1”.

On the Tools menu on the "Worksheet Menu Bar" , I created a submen
item with Caption = “Mtx Browser’”.

My problem is that I have not succeded in coding the “OnAction
property of “Mtx Browser’” to run the procedure identified above.
Help please

 

[Stan Scott]

You can set a click event to a routine in another workbook like this:

Sub SetAction()
Worksheets(1).Shapes(1).OnAction = "Book2.xls!ShowMe"
End Sub

Stan Scott
New York City