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