| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling worksheet module from other module.
I have a module in Sheet1 that automatically refreshes the data
retrieved from a database. I have other modules that could affect that sheet, but if Sheet1, the sheet does not automatically refresh. In order for me to not have to duplicate the code in another module, how would I go about calling the Sheet1 module from another module? Thanks, Mike. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calling worksheet module from other module.
Mike,
Try something like Sheet1.ProcName -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Michael Malinsky" wrote in message oups.com... I have a module in Sheet1 that automatically refreshes the data retrieved from a database. I have other modules that could affect that sheet, but if Sheet1, the sheet does not automatically refresh. In order for me to not have to duplicate the code in another module, how would I go about calling the Sheet1 module from another module? Thanks, Mike. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calling worksheet module from other module.
Thanks, Chip. I had never done that before and just couldn't get it
right. Mike. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calling a module | Excel Discussion (Misc queries) | |||
| Run worksheet module code from workbook module? | Excel Programming | |||
| Calling Worksheet SubProcs From Module | Excel Programming | |||
| Calling VBA function that is in another module | Excel Programming | |||
| Calling a module function from a class method | Excel Programming | |||
Hybrid Mode
