Erik,

Not trying to labour or be awkward, but just help you get the best result,
but if she can delete a formula, shoe can just as easily delete a result.
What is your protection then.

If your wife or anyone else is likely to delete your good work, it seems to
me that locking it down is a better solution.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Erik" wrote in message
...
Hi Bob,
I put the formula in because it's the only way I know to do things. I
agree that it's far less work. However, I tested the operability of the
sheet with my wife and the first thing she did was delete the formula from a
handfull of the cells (then asked why my spreadsheet wasn't working). I
can't protect the sheet without conflicting with the code I'm using to
format the cell color. So, although more work for me, I decided that using
a sub to acomplish the task was somewhat more idiot proof.

Erik