View Single Post
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

You'd need to use VBA. Put these in your workbook code module

Private Sub Workbook_BeforePrint(Cancel As Boolean)
With Range("A1")
.Value = Date
.NumberFormat = "dd mmm yyyy"
End With
End Sub

Private Sub Workbook_BeforeSave( _
ByVal SaveAsUI As Boolean, Cancel As Boolean)
With Range("A1")
.Value = Date
.NumberFormat = "dd mmm yyyy"
End With
End Sub

adjust the range reference as desired. Note that this will put the date
in even if the user cancels the save or print.

If you're new to macros, see David McRitchie's "Getting Started with
Macros":

http://www.mvps.org/dmcritchie/excel/getstarted.htm


In article ,
"Mark Sowerbutts" wrote:

Also, how about the "Last Printed" or "Last Saved" date saved to a cell in
the spreadsheet.