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.

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.

Calling worksheet module from other module.
 

Thanks, Chip. I had never done that before and just couldn't get it
right.

Mike.