in the procedure that is making the call put the following code...
Call Sheets(1).myModuleName
where 1 is the sheet index number and myModuleName is, you guessed it, the name of the module being called.
By prefixing the module name with the sheet in which it resides you are pointing the call to another object.
cheers
Matt
-----------------------------------------
|