[Steve[_16_]]

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

[Doug Robbins - Word MVP]

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

[Steve[_16_]]

Thanks Doug!

How do you protect the document for filling in forms?

Steve


"Doug Robbins - Word MVP" wrote in message
...
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" wrote in message
m...
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

[PamC via OfficeKB.com]

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.a...neral/200812/1

[Steve[_16_]]

Thank You!!!


"PamC via OfficeKB.com" u43222@uwe wrote in message
news:8f274b9dc078d@uwe...
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.a...neral/200812/1

[Doug Robbins - Word MVP]

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" wrote in message
m...
Thanks Doug!

How do you protect the document for filling in forms?

Steve


"Doug Robbins - Word MVP" wrote in message
...
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" wrote in message
m...
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