How do I enter the date last modified in the footer of an Excel d.

G

Guest

How do I enter the date last modified in the footer of an Excel document?
I want to be able to distribute a monthly or weekly report in Excel to users
and have it automatically update the date last modified in the footer each
time I update the report.
 
M

Myrna Larson

You need to do that with a Before_Print event macro. If you search the
newsgroups from Google you will find lots of examples.
 

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

How do I add the last modified date to the footer in Excel? 1
How do I insert the date modified in a spreadsheet footer? 6
How do I add the file last modified date into an Excel header? 3
Date last modified - for entire workbook 3
Including the modified date in the footer 6
How to put save date in the header (or footer) 10
Printing Excel File Custom Properties in the Footer 3
How do I enter the contents of a cell into a page header 1

Top