How do I the protect text box in Excel
 

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?

How do I the protect text box in Excel
 

"pbuck" wrote in message
...
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.

How do I the protect text box in Excel
 

Dear Doug:

Thank you for the suggestion, but I don't have a "Protection" tab in my
Format Text Box window. I have a "Properties" tab, but it doesn't let me
lock anything.

My worksheet is protected and all my cells are locked.

What you told me is how I think it should work!

Have I missed something?



"Doug Kanter" wrote:


"pbuck" wrote in message
...
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.

How do I the protect text box in Excel
 

Hmmm....I'm using Excel 2000. I wonder if they're different. In the Format
Text Box thing, no other tabs show protection options? Is it possible that
option can be controlled via the normal Excel menus somehow?


"pbuck" wrote in message
...
Dear Doug:

Thank you for the suggestion, but I don't have a "Protection" tab in my
Format Text Box window. I have a "Properties" tab, but it doesn't let me
lock anything.

My worksheet is protected and all my cells are locked.

What you told me is how I think it should work!

Have I missed something?



"Doug Kanter" wrote:


"pbuck" wrote in message
...
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.