Protecting TODAY() after mailing

[Dent]

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.

 

[Dave Peterson]

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

 

[Guest]

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!

(e-mail address removed)

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