I need to lock certain cells but still be able to use a pivot table in the
same workbook, is this possible? i've tried everything

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 .

"craig" wrote:

I need to lock certain cells but still be able to use a pivot table in the
same workbook, is this possible? i've tried everything