pbuck said:
I have inserted text boxes into cells in Excel. I want the user to be able
to
type into them, but not to be able to move them out or their cell or
resize
or reformat them. I can't find documentation that tells me how to do this.
Does anyone know how to do this?
With the mouse cursor hovering over the border of the object (as if you were
going to move or resize it), right click, Format Text Box. Click on the
Protection tab. Check "Locked", but don't check "Lock Text". Click OK.
Here's where things get a bit involved. In order for the previous thing to
work, you have to protect the entire sheet, which means you won't be able to
enter data in normal cells unless you unlock them. On a new sheet, all cells
are locked by default, so when you protect the sheet, you can't type
anything. You have to know which cells you want to be able to work with.
Select those cells, and on the menu, Format, Cells, and on the Protection
tab, uncheck "Locked" for those cells.
Next: Tools, Protection, Protect Sheet. You don't have to use a password - a
blank will work.
