Hi Car Jones,
Try this,
Put below code into thisworkbook's codemodule.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Application.EnableEvents = False
Cancel = True
ActiveWindow.SelectedSheets.PrintPreview
Application.EnableEvents = True
'write\call you macro here
MsgBox "macro runs after print preview"
End Sub
Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!