Excel Cell Protection / Locking Problem

H

HalfGreyhound

Is there a way to protect formulas in a sheet (that is, locking certai
cells and protecting the sheet) while still enabling users to add line
in unlocked areas of the sheet?

I am trying to develop a price quoting form where the user can ad
extra lines (if additional line items are added) while I keep th
structure of the sheet (formulas that total columns, calculate tax an
so forth) intact.

I have a feeling that once I protect a sheet, I am foreclosed fro
adding line no matter what.

Thanks
 
M

michele

have you used Data Validation? This restricts what can
be entered into any particular cell. Highlight a column
or row or any cell. go to Data > Validation. Choose
custom. Type in something like NoNo. If anyone tries to
enter anything but NoNo, it won't let them. This leaves
all your formatting options (including row adding or
deleting)intact. You can choose any number of columns or
rows, or any individual cells for data validation. It
also gives you the option to show a message of your choice.
 
Top