OnAction menu item property coding

[levelyn]

Hi again,

Maybe my 1st post could have been more precise. I hope this bette
explains my problem: on the “Tools” menu on the "Worksheet Menu Bar" i
a submenu item with Caption “Mtx Browser’”.

Clicking the menu item “Mtx Browser’” must use its “OnAction” propert
to start and Run the Module(“Module1”) of th
Workbook(“MtxBrTcc1.xls”). Much thanks to someone who provides th
right side of the statement below ...

Workbooks(“MtxBrTcc1.xls”).CommandBar("Worksheet Menu Bar") _
.CommandBarControl(“Tools”) _
.CommandBarControl(“Mtx Browser”) _
.OnAction

 

[BrianB]

We do not run a module, we run a subroutine contained in the module. S
the line would be something like :-


Code

 

[levelyn]

We do not run a module, we run a subroutine contained in th
module. So the line would be something like :-
Code

Bingo! Thanks again. 10-