Adding Last Saved Date to Header

[cardan]

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!

 

[Ron de Bruin]

Hi cardan

See
http://www.rondebruin.nl/print.htm#Last

You can use the BeforeSave event instead of the BeforePrint event if you want

 

[cardan]

Hi cardan

Seehttp://www.rondebruin.nl/print.htm#Last

You can use the BeforeSave event instead of the BeforePrint event if you want

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm








- Show quoted text -

Thank you for the response. It seems to be working well. However, I do
have some formatting issues. I had the header underlined and
italicized before, however, this macro erases the formatting. Is there
a way to write in the font style, size, underline and italicized into
the macro? Thanks again for your help!

 

[Ron de Bruin]

Hi cardan

See this example where you can see how you can add formatting
http://www.rondebruin.nl/print.htm#not