Protect form fields when updating

		Microsoft Office Forums > Microsoft Word > Word VBA
Protect form fields when updating

FAQ

Thread Tools

Display Modes

04-10-2021, 02:14 PM

macropod

Windows 10 Protect form fields when updating

Office 2016

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,465

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]

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:43 AM.