Sorry, meant

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Call SaveMacro
End Sub


--
HTH

Bob Phillips

"Bob Phillips" wrote in message
...
No it would be something like

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Call "SaveMacro"
End Sub

Read the link I gave you.

--
HTH

Bob Phillips

"Losse" wrote in
message ...

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

If Workbook_BeforePrint = true Then
Call "SaveMacro"
End If


--
Losse
------------------------------------------------------------------------
Losse's Profile:
http://www.excelforum.com/member.php...o&userid=24813
View this thread:
http://www.excelforum.com/showthread...hreadid=386133