ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Locked Text box (https://www.excelbanter.com/setting-up-configuration-excel/144470-locked-text-box.html)

OHumphries

Locked Text box
 
How do I unlock only a text box in a protected worksheet?

JLatham

Locked Text box
 
You'll need to unprotect the sheet to make this change and after this is
done, put it back into protected state.

Select the textbox, right click along the edge so you get the option to
[Format Textbox...] showing in a list. Click that and go to the Properties
tab in the dialog and clear the appropriate checkboxes. Close dialog, put
sheet back into protected state.

"OHumphries" wrote:

How do I unlock only a text box in a protected worksheet?


OHumphries

Locked Text box
 
Thank you very much.

"JLatham" wrote:

You'll need to unprotect the sheet to make this change and after this is
done, put it back into protected state.

Select the textbox, right click along the edge so you get the option to
[Format Textbox...] showing in a list. Click that and go to the Properties
tab in the dialog and clear the appropriate checkboxes. Close dialog, put
sheet back into protected state.

"OHumphries" wrote:

How do I unlock only a text box in a protected worksheet?


spooze27

Locked Text box
 
I tried the suggestion to right click on the text box border, but I don't see
"properties" in the dialogue box. I'm using WORD 2003. Thanks!

"OHumphries" wrote:

How do I unlock only a text box in a protected worksheet?


Dave Peterson

Locked Text box
 
If you're using Word 2003, then maybe asking in a Word newsgroup would give you
better responses.



spooze27 wrote:

I tried the suggestion to right click on the text box border, but I don't see
"properties" in the dialogue box. I'm using WORD 2003. Thanks!

"OHumphries" wrote:

How do I unlock only a text box in a protected worksheet?


--

Dave Peterson


All times are GMT +1. The time now is 06:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com