lock certain cells

[mspincus]

I have a price worksheet with drop down menus. the salespeople can fill in all data necessary and it will calculate pricing and sales tax etc. the problem is that they can also change fornulas by typing over a formula. how do you protect certain cells but still allow functionality
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[VoG]

Select the cells that can be changed, Format > Cells > Protection tab. Untick Locked. Then Tools > Protection > Protect Sheet.

 

[mspincus]

thank you!
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">