Securing Formulas

[Guest]

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

 

[Guest]

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.

 

[Guest]

Thanks so much
Wonder if you can help on this next question?

I have created a drop down box with a list of products people can buy.
Once I select that product from the drop down box i want the price to appear
on the next cell beside it.
Can i do this?
And can i reapeat to have the sale price, tax and total come up in their
consecutive cells as well?

Thanks

 

[Guest]

Probably I would set up a lookup table. If A7 is the drop down (I assume it
is a drop down created w/Data Validation and not a drop down created using
either the forms or control toolbox toolbars):

A B
1 Product Price
2 widgets $5.00
3 gadgets $10.00
4
5
6
7 gadgets =Vlookup(A7,$A$2:$B$3,2,FALSE)


Check excel help for Vlookup. Also, Debra Dalgleish's has some additional
notes and examples for Vlookup at:
http://www.contextures.com/xlFunctions02.html