We solved a similar problem by writing a VB routine that
uses an event called WorkbookBeforeSave. We were trying to
automatically insert a date stamp the moment an adjacent
cell took on a particular value for future reference w/o
having this date get updated every time the workbook was
re-opened (as happens with now() or today()) and this made
it work. It will make certain the date does not change if
the contents of the adjacent cell are still the same.
-----Original Message-----
Search for "System Date/Time into a Cell or within Code"
on David
McRitchie's WebPage for insight into how to handle this
issue.

http://www.mvps.org/dmcritchie/excel/datetime.htm

HTH
Paul
----------------------------------------------------------
----------------------------------------------------
Be advised to back up your WorkBook before attempting to
make changes.
----------------------------------------------------------
----------------------------------------------------
On Sat, 27 Sep 2003 15:04:56 GMT, "M. lane"
wrote:

My question; is there a way to enter a date in a cell
that will not update
each time I re-open the workbook, but rather go to the
next row in that
column and enter a new date.

.