Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
How do I unlock only a text box in a protected worksheet?
|
#2
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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? |
#5
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I insert a "locked 'top text'" in a document? | Excel Discussion (Misc queries) | |||
Combobox locked | Excel Discussion (Misc queries) | |||
locked file | Excel Discussion (Misc queries) | |||
Paste text into a locked or hidden cell | Excel Discussion (Misc queries) | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions |