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