How would I get it to run automatically as soon as an event occurs?
doubt this would work, but could I do something with a similar ide
to:

If Workbook_BeforePrint = true Then
Call "SaveMacro"
End I

--
Loss
-----------------------------------------------------------------------
Losse's Profile: http://www.excelforum.com/member.php...fo&userid=2481
View this thread: http://www.excelforum.com/showthread.php?threadid=38613