A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Formatting Cells with restricted access in Word Only



 
 
Thread Tools Display Modes
  #1  
Old January 13th, 2010, 08:11 PM posted to microsoft.public.word.tables
Shoo ofc assistant
external usenet poster
 
Posts: 1
Default Formatting Cells with restricted access in Word Only

I need to restrict text access in some cells and not in others. Is this
possible in word.
I usually work in excel to do this, however, I need to re-format a word
table form if possible. Thanks in advance for any suggestions.
  #2  
Old January 13th, 2010, 09:32 PM posted to microsoft.public.word.tables
Jay Freedman
external usenet poster
 
Posts: 9,488
Default Formatting Cells with restricted access in Word Only

Shoo ofc assistant wrote:
I need to restrict text access in some cells and not in others. Is
this possible in word.
I usually work in excel to do this, however, I need to re-format a
word table form if possible. Thanks in advance for any suggestions.


If you have Word 2007, and the users who fill in the form also have Word
2007, there is a simple way. Click Review Protect Document Restrict
Formatting and Editing. Check the box under "2. Editing restrictions". Leave
the dropdown at "No changes (Read only)". Select a cell or group of cells
that should be editable, and in the Exceptions area, check the box for
Everyone. Repeat for other cells or groups of cells. Click the Start
Enforcing Protection button, and supply a password if desired (or leave it
blank). This protection can be made more flexible by entering user names or
email addresses of people who should have special permissions.

If you or any of the users have Word 2003 or earlier, that method isn't
available. Instead, you may be able to use form fields and forms protection
(http://www.computorcompanion.com/LPMArticle.asp?ID=22).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.


  #3  
Old February 3rd, 2010, 02:54 PM posted to microsoft.public.word.tables
Barbara
external usenet poster
 
Posts: 306
Default Formatting Cells with restricted access in Word Only

I am trying to do the same thing. I have another thread going called For use
in 2003. My template has to be compatible with 2003 as all users are not on
2007. I'm finding I can't do what I want to do in 2007 and it work in 2003.
The drop-downs don't come across nor the unenabled fill-in fields.

Can you do the restricted tables in 2003 and insert that doc as an object in
2007 template and it work correctly?
--
Barbara R


"Jay Freedman" wrote:

Shoo ofc assistant wrote:
I need to restrict text access in some cells and not in others. Is
this possible in word.
I usually work in excel to do this, however, I need to re-format a
word table form if possible. Thanks in advance for any suggestions.


If you have Word 2007, and the users who fill in the form also have Word
2007, there is a simple way. Click Review Protect Document Restrict
Formatting and Editing. Check the box under "2. Editing restrictions". Leave
the dropdown at "No changes (Read only)". Select a cell or group of cells
that should be editable, and in the Exceptions area, check the box for
Everyone. Repeat for other cells or groups of cells. Click the Start
Enforcing Protection button, and supply a password if desired (or leave it
blank). This protection can be made more flexible by entering user names or
email addresses of people who should have special permissions.

If you or any of the users have Word 2003 or earlier, that method isn't
available. Instead, you may be able to use form fields and forms protection
(http://www.computorcompanion.com/LPMArticle.asp?ID=22).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.


.

  #4  
Old February 4th, 2010, 01:19 AM posted to microsoft.public.word.tables
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Formatting Cells with restricted access in Word Only

In which case you will have to use the method in the article to which Jay
referred you - http://www.computorcompanion.com/LPMArticle.asp?ID=22

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"Barbara" wrote in message
...
I am trying to do the same thing. I have another thread going called For
use
in 2003. My template has to be compatible with 2003 as all users are not
on
2007. I'm finding I can't do what I want to do in 2007 and it work in
2003.
The drop-downs don't come across nor the unenabled fill-in fields.

Can you do the restricted tables in 2003 and insert that doc as an object
in
2007 template and it work correctly?
--
Barbara R


"Jay Freedman" wrote:

Shoo ofc assistant wrote:
I need to restrict text access in some cells and not in others. Is
this possible in word.
I usually work in excel to do this, however, I need to re-format a
word table form if possible. Thanks in advance for any suggestions.


If you have Word 2007, and the users who fill in the form also have Word
2007, there is a simple way. Click Review Protect Document Restrict
Formatting and Editing. Check the box under "2. Editing restrictions".
Leave
the dropdown at "No changes (Read only)". Select a cell or group of cells
that should be editable, and in the Exceptions area, check the box for
Everyone. Repeat for other cells or groups of cells. Click the Start
Enforcing Protection button, and supply a password if desired (or leave
it
blank). This protection can be made more flexible by entering user names
or
email addresses of people who should have special permissions.

If you or any of the users have Word 2003 or earlier, that method isn't
available. Instead, you may be able to use form fields and forms
protection
(http://www.computorcompanion.com/LPMArticle.asp?ID=22).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.


.


  #5  
Old February 4th, 2010, 04:21 PM posted to microsoft.public.word.tables
Barbara
external usenet poster
 
Posts: 306
Default Formatting Cells with restricted access in Word Only

Thanks. I had looked at that. I'm actually doing that in 2003. For some
reason in 2007 if I save in compatible mode, it does not work.
--
Barbara R


"Doug Robbins - Word MVP" wrote:

In which case you will have to use the method in the article to which Jay
referred you - http://www.computorcompanion.com/LPMArticle.asp?ID=22

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"Barbara" wrote in message
...
I am trying to do the same thing. I have another thread going called For
use
in 2003. My template has to be compatible with 2003 as all users are not
on
2007. I'm finding I can't do what I want to do in 2007 and it work in
2003.
The drop-downs don't come across nor the unenabled fill-in fields.

Can you do the restricted tables in 2003 and insert that doc as an object
in
2007 template and it work correctly?
--
Barbara R


"Jay Freedman" wrote:

Shoo ofc assistant wrote:
I need to restrict text access in some cells and not in others. Is
this possible in word.
I usually work in excel to do this, however, I need to re-format a
word table form if possible. Thanks in advance for any suggestions.

If you have Word 2007, and the users who fill in the form also have Word
2007, there is a simple way. Click Review Protect Document Restrict
Formatting and Editing. Check the box under "2. Editing restrictions".
Leave
the dropdown at "No changes (Read only)". Select a cell or group of cells
that should be editable, and in the Exceptions area, check the box for
Everyone. Repeat for other cells or groups of cells. Click the Start
Enforcing Protection button, and supply a password if desired (or leave
it
blank). This protection can be made more flexible by entering user names
or
email addresses of people who should have special permissions.

If you or any of the users have Word 2003 or earlier, that method isn't
available. Instead, you may be able to use form fields and forms
protection
(http://www.computorcompanion.com/LPMArticle.asp?ID=22).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.


.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:34 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.