Protecting TODAY() after mailing
 

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

Protecting TODAY() after mailing
 

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

Protecting TODAY() after mailing
 

This would be an ideal situation to learn to use a Macro. You could record
your own that will take Dave's advice and do the steps automatically.

Then set it up so you only mail the sheet that the recipient
needs--retaining your original for yourself.

Good luck!



"Dave Peterson" wrote:

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