A1 will only change if the worksheet is updated.


If you change a cell's value via editting, then A1 should update.
--
Gary's Student
gsnu200701


"R Mallory" wrote:

Thank you so much for your help. I pasted the code, then used file return to
Excel to get out. I saved the file, but I don't see any value in A1. I've
tried formatting A1 to text and date, but there is nothing. Did I miss
something? Funny thing, my wife's family nickname is Garry.

"Gary''s Student" wrote:

Put this in worksheet code:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Cells(1, 1).Value = Now
Application.EnableEvents = True
End Sub

Whenever the sheet is changed the date/time is placed in cell A1

To insert the code:
1. Right-click the tabname at the bottom
2. Select View Code (near the bottom)
3. paste the stuff in
--
Gary's Student
gsnu200701


"R Mallory" wrote:

I would like to display the last time a spreadsheet was updated as it is
updated by more than one person. It would be great if I did not have to
count on each person putting the time of their update in a cell. The Now
function won't work because that changes when you open the file. I am using
Excel 2003.

Thanks for any help.