A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I keep the "today()" function from updating



 
 
Thread Tools Display Modes
  #1  
Old January 9th, 2010, 05:58 PM posted to microsoft.public.excel.worksheet.functions
Len Chaston
external usenet poster
 
Posts: 4
Default How do I keep the "today()" function from updating

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?
  #2  
Old January 9th, 2010, 06:30 PM posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_]
external usenet poster
 
Posts: 2,297
Default How do I keep the "today()" function from updating

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



  #3  
Old January 10th, 2010, 05:23 AM posted to microsoft.public.excel.worksheet.functions
Rick Rothstein[_2_]
external usenet poster
 
Posts: 2,013
Default How do I keep the "today()" function from updating

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?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.