It would be much easier for someone to give you an answer if you posted the
macro's code for us to see.

--
Rick (MVP - Excel)


"Len Chaston" wrote in message
...
I have a macro that adds a new line to our construction budgets. It puts
the
date of the change by using the today function to put that day's date in
the
first cell of the new row.
In Excel 2003, this date would remain static, which is what I wanted.
When
I upgraded to Excel 2007, the date would change to the current date, which
made the information useless.
How can I get the date to remain the date it was first inserted in the
cell?