lock certain cells

mspincus

New Member
Joined
Jul 30, 2010
Messages
30
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">
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,651
Select the cells that can be changed, Format > Cells > Protection tab. Untick Locked. Then Tools > Protection > Protect Sheet.
 

mspincus

New Member
Joined
Jul 30, 2010
Messages
30
thank you!
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
 

Watch MrExcel Video

Forum statistics

Threads
1,095,405
Messages
5,444,276
Members
405,279
Latest member
karen1

This Week's Hot Topics

Top