ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Run worksheet module code from workbook module? (https://www.excelbanter.com/excel-programming/337199-run-worksheet-module-code-workbook-module.html)

keithb

Run worksheet module code from workbook module?
 
How can you run code that exists in a worksheet module from a command in the
workbook module?

Thanks,

Keith



Vasant Nanavati

Run worksheet module code from workbook module?
 
For example:

Sheet1.MyMacro

However, this is generally not advisable as worksheet and workbook macros
should be related only to event procedures, as a matter of good programming
practice.

--

Vasant


"keithb" wrote in message
...
How can you run code that exists in a worksheet module from a command in
the workbook module?

Thanks,

Keith





All times are GMT +1. The time now is 11:13 PM.

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