Protecting cell ranges

[tojomojo]

I have some cells with Formulae in and at times users need to use CLEAR to empty cell content but I dont want them to CLEAR cells with formulae in.

Normal protection appears to lock the whole sheet and I just want to protect cell ranges....

Is there a way to do that?

 

[Fluff]

Select all the cells & set them to Unlocked, then select the columns you want to protect & set the to locked.