Entering Data Into Text Boxes and Worksheet Protection

  • Thread starter Thread starter Skihde
  • Start date Start date
S

Skihde

I'm wondering if there's a way to enter data into a text box once a
worksheet has been protected. Currently, once the sheet is protected,
there's no way to enter data into a text box.

Any thoughts appreciated. Thanks.
Stephan
 
There are two different textboxes--one from the drawing toolbar and one from the
control toolbox toolbar.

But you can rightclick on each and choose:
format control (or Format CheckBox
There's a tab call protection.
Each has a Lock option. (the drawing toolbar has Locked and Lock Text)

After I unchecked each of them, I could use them (when I protected the
worksheet).
 
You can enter data into a text box while a sheet is
protected. Possibly you have used the wrong terminology
and you what you wanted to ask was how to enter data into
a cell in a protected worksheet. To do this, unprotect
your sheet, right-click the cell you need to use, select
Format Cells from the menu, click the Protection tab,
uncheck the Locked option, protect your sheet.
 
Wow Dave, thanks a million--I missed the format part for text boxes--I
kept only getting "Font," but when I right-clicked on the fully shaded
box, I got the whole menu. Thanks.
 
Back
Top