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.