EXcel VBA - OnAction menu item property

L

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
 
S

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
 
Top