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?