Select all of your cells (click the grey box diagonal of cell A1). Click
Format/Cells/Protection - check Lock.

Then select your quantity field and unlock those cells (same steps as above).

Then apply worksheet protection (Tools/Protection/Protect Sheet). Enter a
password if you wish.

Only the unlocked cells can be modified. Note that worksheet protection is
weak if someone really wants to break it - so don't rely on it for sensitive
data.


"bird007" wrote:

Hi there,

I would like to secure some columns in my worksheet so that users can only
update the quantity field.
How do I stop them from entering data in my subtotal columns?

Thanks, as you can tell im not a master at excel :)