Erik,
In the ThisWorkbook code module, use something like
Private Sub Workbook_Open()
Worksheets("Sheet1").Range("A1").Value = Now
End Sub
Change the sheet name and the cell reference to your needs.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Erik" wrote in message
...
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