software

I have a spreadsheet that I send to other people and it has a cell that has
today's date in it (now() function). I don't want this date to change after
I have sent the spreadsheet. I have tried locking the cell and protecting
the spreadsheet, but the cell still calculates a new date every time it is
opened. Is there a way to not have one cell recalculate? I can turn off
automatic calculations, but this is not practical. Any ideas would be
appreciated.

Thanks
Hi tk. The only way I can think of is to copygt;paste specialgt;value before
sending. Perhaps one of the MVP's could provide some event code so that when
you close the file it would do it for you and then when you re open the file,
insert the Now () function back in. I'm afraid my skills are not at that
level - yet. HTH
--
Sincerely, Michael Colvinquot;tkquot; wrote:

gt; I have a spreadsheet that I send to other people and it has a cell that has
gt; today's date in it (now() function). I don't want this date to change after
gt; I have sent the spreadsheet. I have tried locking the cell and protecting
gt; the spreadsheet, but the cell still calculates a new date every time it is
gt; opened. Is there a way to not have one cell recalculate? I can turn off
gt; automatic calculations, but this is not practical. Any ideas would be
gt; appreciated.
gt;
gt; Thanks
gt;
gt;
gt;