anon

You could use Event code in a worksheet.

See J.E. McGimpsey's TimeStamp page.

http://www.mcgimpsey.com/excel/timestamp.html


Gord Dibben Excel MVP




On Mon, 1 Mar 2004 12:22:11 -0800,
wrote:

Can a derivative of this work for stamping a cell when an
adjacent cell is updated?


-----Original Message-----
Hi
you may put the following code in your workbook module

Private Sub Workbook_Open()
Worksheets("Sheet1").Select
Range("A1").Value = now
End Sub


--
Regards
Frank Kabel
Frankfurt, Germany

Erik wrote:
I am trying to place a date/time stamp in one cell that
is updated
when the sheet is opened. What is the best way to do
this? Erik
.