I have a worksheet cell which uses the Today() function. A macro
controls other data entry, and printing functions for this worksheet. I
created this worksheet quite some time ago and now find myself needing
to duplicate most of the macro processes on a new worksheet. I've
basically copied this worksheet and modified the macro as needed. My
problem is that with the old worksheet, when a completed sheet is saved
then reopened, the cell that contained the Today() function is not
updated with the current date. That cells contents show the current
date instead of the function. With my new worksheet the Today()
function remains and the cell is updated with the current date, which I
don't want. I have been unable to find the difference in the code that
is causing this behavior. Can anyone point me where to look or explain
what might be going on?

BrianG



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!