Evaluating Today() function only once in a worksheet
 

Hello,

I've created excel worksheet that auto-populates certain cells with today's
date to facilate filling out a purchase order worksheet.

But problem is once i save the worksheet, and open it at some other date
the Today() function gets executed again a re-populates those cells with
today's date, instead of keeping the original date. HOw can i prevent this
from happening so that when the worksheet is opened at some future day, those
cells will retain the original date.

Oops, forgot to add the requirement that i do not want to add any VB code to
the worksheet. ie. I don't want to add VB code to the workbook_open event to
resolve this issue.

Thanks!

"BW" wrote:

Hello,

I've created excel worksheet that auto-populates certain cells with today's
date to facilate filling out a purchase order worksheet.

But problem is once i save the worksheet, and open it at some other date
the Today() function gets executed again a re-populates those cells with
today's date, instead of keeping the original date. HOw can i prevent this
from happening so that when the worksheet is opened at some future day, those
cells will retain the original date.

Hi!

You have 2 options:

1. use VBA code
2. hardcode the date

I can't help with 1.

For 2, you can just enter the date in one cell and link the other date cells
to that one cell.

CTRL ; (semicolon) enters the date.

Biff

"BW" wrote in message
...
Hello,

I've created excel worksheet that auto-populates certain cells with
today's
date to facilate filling out a purchase order worksheet.

But problem is once i save the worksheet, and open it at some other date
the Today() function gets executed again a re-populates those cells with
today's date, instead of keeping the original date. HOw can i prevent
this
from happening so that when the worksheet is opened at some future day,
those
cells will retain the original date.

or copy paste special value
--
paul
remove nospam for email addy!



"Biff" wrote:

Hi!

You have 2 options:

1. use VBA code
2. hardcode the date

I can't help with 1.

For 2, you can just enter the date in one cell and link the other date cells
to that one cell.

CTRL ; (semicolon) enters the date.

Biff

"BW" wrote in message
...
Hello,

I've created excel worksheet that auto-populates certain cells with
today's
date to facilate filling out a purchase order worksheet.

But problem is once i save the worksheet, and open it at some other date
the Today() function gets executed again a re-populates those cells with
today's date, instead of keeping the original date. HOw can i prevent
this
from happening so that when the worksheet is opened at some future day,
those
cells will retain the original date.

Thanks for responding gentlemen.

Decided that i had to use a single line of VB code inside the template's
workbook_open method to do the trick:

Private Sub Workbook_Open()
If ThisWorkbook.Path = "" Then Sheet1.Range("Start_Date").Value = Now
End Sub



"paul" wrote:

or copy paste special value
--
paul
remove nospam for email addy!



"Biff" wrote:

Hi!

You have 2 options:

1. use VBA code
2. hardcode the date

I can't help with 1.

For 2, you can just enter the date in one cell and link the other date cells
to that one cell.

CTRL ; (semicolon) enters the date.

Biff

"BW" wrote in message
...
Hello,

I've created excel worksheet that auto-populates certain cells with
today's
date to facilate filling out a purchase order worksheet.

But problem is once i save the worksheet, and open it at some other date
the Today() function gets executed again a re-populates those cells with
today's date, instead of keeping the original date. HOw can i prevent
this
from happening so that when the worksheet is opened at some future day,
those
cells will retain the original date.