the easiest way is to use the beforeprint event. Then return Cancel so
excel doesn't run the real pring routine

Private Sub Workbook_BeforePrint(Cancel As Boolean)
For Each wk in Worksheets
wk.Calculate
Next
End Sub



You could also creatte a class module that overrides the real print
function.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=197295

http://www.thecodecage.com/forumz