Thread: Help with Calling Routines

Hi Everyone

I have a routine in Excel 2007 in the 'Sheet1' object. This routine calls another routine "Sub NotifyIT()" which is in the stored in the 'ThisWorkbook' object.

I am getting a compile error "Sub or Function not Defined" at this line of my code:

Call NotifyIT

The "NotifyIT" routine can be called by both the routine in Sheet1 or by the BeforePrint event. Is there a way both can call the NotifyIT routine without me having two copy it to both objects?

Thanks!

HappyHole

Thanks Marvin, that is helpful.
The original routine controls lots of shapes and objects on Sheet1. I can move the code into a Standard Code Module but presumably then need to add sheet name references to all the instances of code that refer to an object sitting in sheet one right?

Thanks.

HH