Creating a macro to print the date a document was last saved.

J

Judi

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
 
S

Shane Devenshire

Hi,

Try adding

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

If this helps, please click the Yes button,

Cheers,
Shane Devenshire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last Save Date 1
can anyone help with the code for creating a aut print macro... 1
macro to print xps then save with name value in (B2) 8
Macro to automatically print & save as PDF 2
Last Saved Date in Footer (right aligned) 8
Create a log sheet 7
Help to create a macro 2
Defining a print area in a macro 1

Top