Craig,
I've been struggeling with a similar problem over the past few days. I've
done some investigation without finding a simple solution. I my case I needed
mostly to protect formulas, that was my main objective.
The solution I've ended up with is : having VBA code in the
worksheet_change() procedure to restore the formula if the user changes the
cell content. The result works fine, but as said - only the formulas are
protected. Format and other properties can still be changed.
If your interested in the approach I can send you the VBA code I used. Mail
me on
[email protected].
