View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default Creating a macro to print the date a document was last saved.

Hi,

Try adding

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader =
ActiveWorkbook.BuiltinDocumentProperties.Item("Las t Save Time")
End Sub

If this helps, please click the Yes button,

Cheers,
Shane Devenshire

"Judi" wrote in message
...
By the way, I'm in '07.

"Judi" wrote:

Good morning!

I am looking to add a macro to a workbook that will automatically print
the
date last saved (in the bottom right corner, I think).

Can you help?

THANK YOU!

~judi