Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Last modified date in footer
 
Posts: n/a
Default How do I enter the date last modified in the footer of an Excel d.

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.
  #2   Report Post  
Myrna Larson
 
Posts: n/a
Default

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

On Fri, 4 Feb 2005 09:33:04 -0800, "Last modified date in footer" <Last
modified date in wrote:

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
How do I change the default date format in an Excel Footer Burki Setting up and Configuration of Excel 1 February 4th 05 03:15 AM
How do I enter a date before 1900 in excel? woodrat Excel Worksheet Functions 3 January 14th 05 03:39 PM
How do I enter a date before 1900 in excel? woodrat Excel Worksheet Functions 1 January 14th 05 11:37 AM
Excel: How do I enter a date in one cell & automatically dates adj Shannon Excel Discussion (Misc queries) 4 January 12th 05 01:51 AM


All times are GMT +1. The time now is 03:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"