Latest Modification Date Automatically Printed

P

Pedro

I am new to Excel and I have a pretty elementary question that I could
not find an answer for. I want to indicate on the Excel spreadsheet
when it prints out the last date I have modified the spreadsheet. I
would like to have that printed out automatically, without my having to
enter the date each time I change the spreadsheet. Any advice would be
appreciated.

Pedro
 
B

Bob Phillips

Private Sub Workbook_BeforePrint(Cancel As Boolean)
With ActiveSheet.PageSetup
.LeftFooter ActiveWorkbook.BuiltinDocumentProperties.Item("Last Save
Time")
End With
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top