How to disable a cell . . . ??

  • Thread starter Thread starter hays4
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
YouTube error: "If playback doesn't begin shortly, try restarting your device" 0
Can't change the cell back to blank when there is a date in it. 0
Mutiply in a range of cells ? 1
Conditional formatting based on formula cell 6
Last Modified By in a cell by user 3
Automatically chnage number format of a range of cells 2

Back
Top