#1
|
|||
|
|||
Protect form fields when updating
Hey Guys, I've been using this macro for many years to protect form fields when updating them-until now. Suddenly in 365 this macro does not work. It does not select all the text in the doc, nor does it update the fields. Has there been a change in the VBA code language? Here's the macro-
Code:
Sub UpdateAllFields() ' UpdateAllFields Macro If ActiveDocument.ProtectionType = wdNoProtection Then ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True End If If ActiveDocument.ProtectionType <> wdNoProtection Then ActiveDocument.Fields.Update ActiveDocument.Unprotect End If End Sub |
#2
|
||||
|
||||
Why are you protecting the document before updating the fields fields, then unprotecting it afterwards? That shouldn't be necessary and seems a strange way to go about things. Try:
Code:
Sub UpdateFields() Application.ScreenUpdating = False With ActiveDocument .Fields.Update .PrintPreview .ClosePrintPreview End With Application.ScreenUpdating = True End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Seeing that I or someone wrote that macro some 8 of so years ago, why it was written that way would be pure speculation.
Questions-what does print preview do code wise and why use it? (curious, want to learn). Given that there are a lot of form fields in these forms, and the people using them are let's say less than computer genius material, should I write an exit macro to protect the individual fields after they are filled in? Thanks Paul, you are the best- |
#4
|
||||
|
||||
Quote:
Ordinarily, one shouldn't need a macro to update fields in a document using formfields. All that should be needed is for the formfields upon which any updates are to be based should have their' Calculate on Exit' property checked.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to protect cells and still be able to use all data entry form | Jae | Excel | 2 | 11-13-2019 05:32 PM |
Auto-Updating Text Fields in Form Fill doc | strodden | Word | 2 | 08-28-2017 07:01 AM |
Macro to keep formatted form fields after mail merge or replace text with formatted form fields | jer85 | Word VBA | 2 | 04-05-2015 10:00 PM |
Updating field codes without clearing form fields | wwwKris | Word | 1 | 08-29-2014 07:03 AM |
Protect certain parts of a form | --emma-- | Word | 0 | 07-20-2010 12:27 PM |