View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cardan cardan is offline
external usenet poster
 
Posts: 112
Default Adding Last Saved Date to Header

Hello all,

I am trying to find a way to automatically put the last saved date
into the header of an excel document. Is there an easy macro that can
replace the last saved date every time the document is saved?
Essentially, I need it to look like this

Last Update: (last saved date)

I have only recorded a few basic macros that run with certain
keystrokes. (Ctrl+Shift+Q, etc...). However I have never written one
that will run when the event is saving/ saving while exiting. How
would I go about inserting this into my workbook? Any help is greatly
appreciated. Thank you in advance!