ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   OnAction menu item property coding (https://www.excelbanter.com/excel-programming/303888-re-onaction-menu-item-property-coding.html)

BrianB

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


Code
-------------------
.OnAction = “MtxBrTcc1.xls!MySubRoutine
-------------------


--
Message posted from http://www.ExcelForum.com


levelyn

OnAction menu item property coding
 
BrianB wrote:
We do not run a module, we run a subroutine contained in th
module. So the line would be something like :-


Code
-------------------
.OnAction = “MtxBrTcc1.xls!MySubRoutine

-------------------
:)

Bingo! Thanks again. 10-

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com