Protect form fields when updating

macropod · #1 04-10-2021, 02:14 PM

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

brent chadwick · #2 04-11-2021, 01:12 PM

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-

macropod · #3 04-11-2021, 02:46 PM

Quote:

Originally Posted by brent chadwick

what does print preview do code wise and why use it? (curious, want to learn)

Toggling Print Preview updates fields that are not updated via Fidlds.Update.

Quote:

Originally Posted by brent chadwick

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?

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.

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