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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |