Protecting TODAY() after mailing

D

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.
 
D

Dave Peterson

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

Jacob_F_Roecker

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!

[email protected]

Dave Peterson said:
You could convert those cells to values (edit|copy, edit|paste special|values is
one way) before you send the file.
Click to expand...
 
Top