Maybe you could use the workbook_beforeprint event to have excel calculate.
Then the time/date will update.

This would go under the ThisWorkbook module:

Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Application.Calculate
End Sub


"Patrick C. Simonds" wrote:

In cell H87 I have the formula below which of course gives the time the file
is opened, but it seems I need to have the time the worksheet is printed.
The workbook tends to be open most of the day and is printed each time a
change is made.

=NOW()

--

Dave Peterson