You could convert those cells to values (edit|copy, edit|paste special|values is
one way) before you send the file.

Dent wrote:

I have a worksheet that contains TODAY(), +1, +2 etc function. Is it
possible to stop the dates auto updating after the sheet has been
emailed to the recipient. I want it to preserve the dates ( auto )
inserted when the sheet created.

--
Dent
------------------------------------------------------------------------
Dent's Profile: http://www.excelforum.com/member.php...o&userid=30015
View this thread: http://www.excelforum.com/showthread...hreadid=497071

--

Dave Peterson