 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Tables / April 2004protect individual cells?
i use a form made up of two columns of tables. some of the cells have text to explain the following cell and some of the cells are blank to allow data to be entered. some of the cells have formula that cull information from the data cells. is it possible to turn on cell protection in the non data entry cells so that i can tab through the table only hitting the data entry cells? this was easy in word perfect but so far i can't figure out how to do this in word 2000. Hi Robert You might be able to use Form Fields (aka Proteced Mode Form) for your purpose. Check out the following URL: http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm HTH + Cheers - Peter =?Utf-8?B?Ym9iIHNjaGVtYnJp?= <robert.schembri@gov.ab.ca> wrote in news:F4E02B02-37AC-4B64-9E82-A3AC45EAB7E4@microsoft.com: > i use a form made up of two columns of tables. some of the cells have > text to explain the following cell and some of the cells are blank to [quoted text clipped - 5 lines] > this was easy in word perfect but so far i can't figure out how to do > this in word 2000. Hi Bob, From the View menu, select Toolbars and check the Forms item. Then you can insert formfields in the data cells. You then protect the document and then the tab key will move from one formfield to the next, and the user will only be able to enter data into the formfields. To get up to speed with this type of form in Word, see Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136  SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP >i use a form made up of two columns of tables. some of the cells have text >to explain the following cell and some of the cells are blank to allow data [quoted text clipped - 5 lines] > this was easy in word perfect but so far i can't figure out how to do this > in word 2000. I'm looking for the same answer.......you found one yet? >-----Original Message----- >i use a form made up of two columns of tables. some of the cells have text to explain the following cell and some of the cells are blank to allow data to be entered. some of the cells have formula that cull information from the data cells. >is it possible to turn on cell protection in the non data entry cells so that i can tab through the table only hitting the data entry cells? >this was easy in word perfect but so far i can't figure out how to do this in word 2000. > >. Use formfields in the data cells and protect the document for forms. See Please Fill Out This Form Part 1: Create professional looking forms in Word http://www.computorcompanion.com/LPMArticle.asp?ID=22 Part 2: Adding Automation to your Word forms. http://www.computorcompanion.com/LPMArticle.asp?ID=46 Part 3: Learn more VBA (macros) to automate your forms. http://www.computorcompanion.com/LPMArticle.asp?ID=119 Part 4: Use custom dialog boxes in your Word forms http://www.computorcompanion.com/LPMArticle.asp?ID=127 Part 5: Connect your AutoForm to a database to save input time and keep better records! http://www.computorcompanion.com/LPMArticle.asp?ID=136 SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > I'm looking for the same answer.......you found one yet? > [quoted text clipped - 12 lines] > > > >. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.