![]() |
#6
|
||||
|
||||
![]()
To see how, click Developer > Restrict Editing > Stop Protection.
Then click on the formfield and click Developer > Properties. You'll see that the fomrfield has a bookmark name and an option 'calculate on exit' that is checked. Then press Alt-F9 to expose the field code for the forumula field. That's all there is to it. Do note that, with such a document, you can only enter data in the formfields. If you want to be able to enter data elsewhere, you need to use Section breaks to differentiate the Sections that will/will not have the formfield protection. See attached. For an idea of what can be achieved with formula field coding, check out my Microsoft Word Field Maths Tutorial, at: http://windowssecrets.com/forums/sho...l=1#post320143 or http://www.gmayor.com/downloads.htm#Third_party
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to insert a hyperlink in activex textbox | Joe Patrick | Word VBA | 1 | 10-03-2011 06:03 AM |
textbox color issue | Dave Duncan | Word | 0 | 08-07-2011 10:38 AM |
Motion paths and shrinking textbox | Brin | PowerPoint | 0 | 01-12-2011 10:04 AM |
Textbox Template | t0m46 | Word | 0 | 09-07-2010 03:38 AM |
Creating Chart using VB textbox value | shyler82 | Word VBA | 0 | 03-12-2010 06:56 PM |