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  

Uneditable fields



 
 
Thread Tools Display Modes
  #1  
Old September 8th, 2005, 07:55 PM
Candace
external usenet poster
 
Posts: n/a
Default Uneditable fields

I have a large Word table that we are using as a form. Is it possible to set
some of the cells so that they cannot be edited?
  #2  
Old September 8th, 2005, 08:19 PM
Jean-Guy Marcil
external usenet poster
 
Posts: n/a
Default Uneditable fields

Candace was telling us:
Candace nous racontait que :

I have a large Word table that we are using as a form. Is it possible
to set some of the cells so that they cannot be edited?


Why don't you protect if for form? This feature was designed for that
purpose.
Tools Protect Document...

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site:
http://www.word.mvps.org


  #3  
Old September 8th, 2005, 10:24 PM
Candace
external usenet poster
 
Posts: n/a
Default Uneditable fields

This document also contains mail merge fields, so I cannot use the form
objects because they are not compatible with mail merge features. Is there
any way to set some of the cells in my table so that they cannot be edited?

"Jean-Guy Marcil" wrote:

Candace was telling us:
Candace nous racontait que :

I have a large Word table that we are using as a form. Is it possible
to set some of the cells so that they cannot be edited?


Why don't you protect if for form? This feature was designed for that
purpose.
Tools Protect Document...

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site:
http://www.word.mvps.org



  #4  
Old September 8th, 2005, 11:54 PM
Jean-Guy Marcil
external usenet poster
 
Posts: n/a
Default Uneditable fields

Candace was telling us:
Candace nous racontait que :

This document also contains mail merge fields, so I cannot use the
form objects because they are not compatible with mail merge
features. Is there any way to set some of the cells in my table so
that they cannot be edited?


It can be done, but it means that everybody involved with the document must
have Word 2003.

Otherwise, alternatives are possible, but first, you must describe in more
details what you are doing (I mean as far as the user is concerned, how will
he/she handle the document?).

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site:
http://www.word.mvps.org


  #5  
Old September 9th, 2005, 01:01 PM
Candace
external usenet poster
 
Posts: n/a
Default Uneditable fields

DETAILS: My table contains cells that have merge codes. Data from an Access
database will populate these cells when merged. My table also contains cells
that users will enter figures in. Also, my table has cells that will
calculate the figures entered by the users. The cells that I want to lock are
the cells that contain descriptive information that I do not want users to be
able to edit. For instance, I have a cell that has the word "Fees" in it; to
the right of that cell there is another cell that the user will enter the
appropriate dollar amount. I do not want my user to accidentally click in the
descriptive field that says "Fees" and type figures there. We are using Word
2003. How can I set this form so that users cannot edit cells that contain
info that should not be changed?

"Jean-Guy Marcil" wrote:

Candace was telling us:
Candace nous racontait que :

This document also contains mail merge fields, so I cannot use the
form objects because they are not compatible with mail merge
features. Is there any way to set some of the cells in my table so
that they cannot be edited?


It can be done, but it means that everybody involved with the document must
have Word 2003.

Otherwise, alternatives are possible, but first, you must describe in more
details what you are doing (I mean as far as the user is concerned, how will
he/she handle the document?).

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site:
http://www.word.mvps.org



  #6  
Old September 9th, 2005, 01:30 PM
Jean-Guy Marcil
external usenet poster
 
Posts: n/a
Default Uneditable fields

Candace was telling us:
Candace nous racontait que :

DETAILS: My table contains cells that have merge codes. Data from an
Access database will populate these cells when merged. My table also
contains cells that users will enter figures in. Also, my table has
cells that will calculate the figures entered by the users. The cells
that I want to lock are the cells that contain descriptive
information that I do not want users to be able to edit. For
instance, I have a cell that has the word "Fees" in it; to the right
of that cell there is another cell that the user will enter the
appropriate dollar amount. I do not want my user to accidentally
click in the descriptive field that says "Fees" and type figures
there. We are using Word 2003. How can I set this form so that users
cannot edit cells that contain info that should not be changed?


In Word 2003 use Tools Protect Document...

In the task pane on the left, in section #2, check "No Changes." Then select
text (or a cell) you want users to be able to edit and click on the
"Everyone" checkbox in the Exceptions section of the Task pane (Meaning that
Everyone can edit this selected part of the document). Choose another
editable section and click on "Everyone," and so on.

I have never used this with a mail merge, I do not know if it will work...
let us now!

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site:
http://www.word.mvps.org


  #7  
Old September 9th, 2005, 02:28 PM
Candace
external usenet poster
 
Posts: n/a
Default Uneditable fields

Unfortunately, the Protect Document task pane is "greyed-out" for mail merge
documents, so I can use it's options. Any other ideas?

"Jean-Guy Marcil" wrote:

Candace was telling us:
Candace nous racontait que :

DETAILS: My table contains cells that have merge codes. Data from an
Access database will populate these cells when merged. My table also
contains cells that users will enter figures in. Also, my table has
cells that will calculate the figures entered by the users. The cells
that I want to lock are the cells that contain descriptive
information that I do not want users to be able to edit. For
instance, I have a cell that has the word "Fees" in it; to the right
of that cell there is another cell that the user will enter the
appropriate dollar amount. I do not want my user to accidentally
click in the descriptive field that says "Fees" and type figures
there. We are using Word 2003. How can I set this form so that users
cannot edit cells that contain info that should not be changed?


In Word 2003 use Tools Protect Document...

In the task pane on the left, in section #2, check "No Changes." Then select
text (or a cell) you want users to be able to edit and click on the
"Everyone" checkbox in the Exceptions section of the Task pane (Meaning that
Everyone can edit this selected part of the document). Choose another
editable section and click on "Everyone," and so on.

I have never used this with a mail merge, I do not know if it will work...
let us now!

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site:
http://www.word.mvps.org



  #8  
Old September 9th, 2005, 05:54 PM
Jean-Guy Marcil
external usenet poster
 
Posts: n/a
Default Uneditable fields

Candace was telling us:
Candace nous racontait que :

Unfortunately, the Protect Document task pane is "greyed-out" for
mail merge documents, so I can use it's options. Any other ideas?


I did something like this a few years ago.

I had a form that was protected and did a mail merge with it.

If I remember correctly, I inserted my MERGEFIELD by hand, and then
protected the form.
When the user was ready to proceed with the merge, he used the mailmerge
toolbar. I had modified the bar so that when he clicked on "Merge to new
document" a custom macro was called. The macro unprotected the form and
established the connection with the database and then proceeded with the
merge.

This was with Word 97... but I know it can be done, I just do not have the
time right now to dig up the code.

I am sure that someone has the code, I would suggest at this point that you
start a new thread in the vba.general group asking for info on mailmerging
through vba under Word 2003.

Good luck!

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site:
http://www.word.mvps.org


 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
improving performance by indexing query criteria fields Paul James General Discussion 20 February 16th, 2005 07:55 PM
improving performance by indexing query criteria fields Paul James Running & Setting Up Queries 20 February 16th, 2005 07:55 PM
Can't Add Fields to Form Jeff Miller Using Forms 4 January 12th, 2005 03:42 AM
Outlook contacts doesn't allow all fields from Excel? gnmcewen Contacts 0 January 9th, 2005 04:21 AM
Populate fields in Form Header based on header fields in startup f Pat Dools Using Forms 0 January 7th, 2005 03:19 PM


All times are GMT +1. The time now is 07:44 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.