Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I insert 'date modified' for a whole spreadsheet in the foo
I've found some code on the boards about how to have one cell say when
another cell was modified. But I'm looking to have the something ideally in the header or footer that states "Date Modified: 3/13/2006" for example and it updates each time any cell is modified in the spreadsheet. I suppose this might work to if the date inserted in the code was when the spreadsheet was last saved if that is the only possibility. Any help is greatly appreciated. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I insert 'date modified' for a whole spreadsheet in the foo
Maybe this will do it
Option Explicit Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Dim ws As Worksheet For Each ws In Me.Worksheets ws.PageSetup.LeftHeader = "Date Modified " & _ Format(Date, "dd mmm yyyy") Next ws End Sub This is workbook event code. To input this code, right click on the Excel icon on the worksheet (or next to the File menu if you maximise your workbooks), select View Code from the menu, and paste the code -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "nicycle" wrote in message ... I've found some code on the boards about how to have one cell say when another cell was modified. But I'm looking to have the something ideally in the header or footer that states "Date Modified: 3/13/2006" for example and it updates each time any cell is modified in the spreadsheet. I suppose this might work to if the date inserted in the code was when the spreadsheet was last saved if that is the only possibility. Any help is greatly appreciated. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert date when data is modified | Excel Discussion (Misc queries) | |||
insert the date the file was last modified | Excel Discussion (Misc queries) | |||
How do I insert the date modified in a spreadsheet footer? | Excel Discussion (Misc queries) | |||
Need to insert file modified date of Excel spreadsheet in a cell | Excel Discussion (Misc queries) | |||
insert the date the file was last modified | Excel Discussion (Misc queries) |