Group:  Microsoft Word ยป microsoft.public.word.newusers
Thread: Lock Cells In A Table???

Geek News

Lock Cells In A Table???
"Steve" <nonsense[ at ]nomsense.com> 12/24/2008 12:12:05 AM
Word2007

In a Word2007 table, is there a way to lock cells so that if a cell has
something in it, it can not be modified or if a cell is blank, nothing can
be entered into the cell?

Thanks!

Steve



Re: Lock Cells In A Table???
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/24/2008 1:19:34 AM
In Word alone, only by protecting the document for filling in forms. If you
insert an Excel Spreadsheet to use as your table, you have more flexibility.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Steve" <nonsense[ at ]nomsense.com> wrote in message
news:8N6dndsJT__I48zUnZ2dnUVZ_qzinZ2d[ at ]earthlink.com...
[Quoted Text]
> Word2007
>
> In a Word2007 table, is there a way to lock cells so that if a cell has
> something in it, it can not be modified or if a cell is blank, nothing can
> be entered into the cell?
>
> Thanks!
>
> Steve
>
>
>


Re: Lock Cells In A Table???
"Steve" <nonsense[ at ]nomsense.com> 12/24/2008 5:12:43 PM
Thanks Doug!

How do you protect the document for filling in forms?

Steve


"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> wrote in message
news:O6c$zWWZJHA.556[ at ]TK2MSFTNGP06.phx.gbl...
[Quoted Text]
> In Word alone, only by protecting the document for filling in forms. If
> you insert an Excel Spreadsheet to use as your table, you have more
> flexibility.
>
> --
> Hope this helps.
>
> Please reply to the newsgroup unless you wish to avail yourself of my
> services on a paid consulting basis.
>
> Doug Robbins - Word MVP
>
> "Steve" <nonsense[ at ]nomsense.com> wrote in message
> news:8N6dndsJT__I48zUnZ2dnUVZ_qzinZ2d[ at ]earthlink.com...
>> Word2007
>>
>> In a Word2007 table, is there a way to lock cells so that if a cell has
>> something in it, it can not be modified or if a cell is blank, nothing
>> can
>> be entered into the cell?
>>
>> Thanks!
>>
>> Steve
>>
>>
>>
>
>


Re: Lock Cells In A Table???
"PamC via OfficeKB.com" <u43222[ at ]uwe> 12/24/2008 7:05:03 PM
W2007 has a new feature that may work for you. Try this:
Select the _characters_ in the cell you want to prevent editing in. Go to
Developer tab > Controls group > Group icon. Click the arrow next to the
icon and select Group. If you have selected the cell, the group icon will be
unavailable, but if you select all the characters in the the cell, it will be.


The resulting characters will be uneditable and when you try, the message in
the status bar will say: This modification is not allowed because the
selection is locked.

Since there's no password protection and anyone in the know can ungroup the
text, this method will just prevent accidental entries. Another thing to
consider is that this is a W2007 feature that, I believe, is not transferred
if the file is converted to W2003.

PamC

Steve wrote:
[Quoted Text]
>Word2007
>
>In a Word2007 table, is there a way to lock cells so that if a cell has
>something in it, it can not be modified or if a cell is blank, nothing can
>be entered into the cell?
>
>Thanks!
>
>Steve

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-word-general/200812/1

Re: Lock Cells In A Table???
"Steve" <nonsense[ at ]nomsense.com> 12/24/2008 9:45:48 PM
Thank You!!!


"PamC via OfficeKB.com" <u43222[ at ]uwe> wrote in message
news:8f274b9dc078d[ at ]uwe...
[Quoted Text]
> W2007 has a new feature that may work for you. Try this:
> Select the _characters_ in the cell you want to prevent editing in. Go to
> Developer tab > Controls group > Group icon. Click the arrow next to the
> icon and select Group. If you have selected the cell, the group icon will
> be
> unavailable, but if you select all the characters in the the cell, it will
> be.
>
>
> The resulting characters will be uneditable and when you try, the message
> in
> the status bar will say: This modification is not allowed because the
> selection is locked.
>
> Since there's no password protection and anyone in the know can ungroup
> the
> text, this method will just prevent accidental entries. Another thing to
> consider is that this is a W2007 feature that, I believe, is not
> transferred
> if the file is converted to W2003.
>
> PamC
>
> Steve wrote:
>>Word2007
>>
>>In a Word2007 table, is there a way to lock cells so that if a cell has
>>something in it, it can not be modified or if a cell is blank, nothing can
>>be entered into the cell?
>>
>>Thanks!
>>
>>Steve
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.aspx/ms-word-general/200812/1
>


Re: Lock Cells In A Table???
"Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 12/25/2008 6:49:34 AM
In versions before 2007 from the Tools menu, select Protect. In 2007, on
the Developer tab, click on Protect Document.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Steve" <nonsense[ at ]nomsense.com> wrote in message
news:_NOdnR9j7MYN8M_UnZ2dnUVZ_uadnZ2d[ at ]earthlink.com...
[Quoted Text]
> Thanks Doug!
>
> How do you protect the document for filling in forms?
>
> Steve
>
>
> "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> wrote in message
> news:O6c$zWWZJHA.556[ at ]TK2MSFTNGP06.phx.gbl...
>> In Word alone, only by protecting the document for filling in forms. If
>> you insert an Excel Spreadsheet to use as your table, you have more
>> flexibility.
>>
>> --
>> Hope this helps.
>>
>> Please reply to the newsgroup unless you wish to avail yourself of my
>> services on a paid consulting basis.
>>
>> Doug Robbins - Word MVP
>>
>> "Steve" <nonsense[ at ]nomsense.com> wrote in message
>> news:8N6dndsJT__I48zUnZ2dnUVZ_qzinZ2d[ at ]earthlink.com...
>>> Word2007
>>>
>>> In a Word2007 table, is there a way to lock cells so that if a cell has
>>> something in it, it can not be modified or if a cell is blank, nothing
>>> can
>>> be entered into the cell?
>>>
>>> Thanks!
>>>
>>> Steve
>>>
>>>
>>>
>>
>>
>
>


Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net