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?

Hi

Behaviour has not altered between XL2003 and 2007 in this respect.
If a cell contains =TODAY(), it is volatile and will be recalculated every
time there is a change in the worksheet, so the date will alter day by day.

Perhaps your original macro did something like
ActiveSheet.Range("A" & nextrow)=Date where nextrow is the next row number
on the sheet
In this case the Date would be fixed to the value at the time the macro was
run

It sounds as though the macro now does something like
ActiveSheet.Range("A" & nextrow).Formula = "=Today()"
--
Regards
Roger Govier

"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?

__________ Information from ESET Smart Security, version of virus
signature database 4756 (20100109) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4756 (20100109) __________

The message was checked by ESET Smart Security.

http://www.eset.com

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?