How to disable a cell . . . ??

H

hays4

How would I disable a cell so that it can't be used at all.

I have created a form for users, and I want the cells that they can
enter to be fixed.
 
D

Dave Peterson

You can lock the cells that the users shouldn't change
(formulas/titles/descriptions) and unlock the cells that the user can change.

Select the cell(s)
format|cell|protection tab|check or uncheck locked

Then protect the worksheeet:
tools|protection|protect worksheet

Be aware that there are lots of things you can't do on a protected worksheet --
and that worksheet protection can be broken pretty easily.
 
Top