Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update protected form field with Macro

Status
Not open for further replies.

kabushnell

Technical User
Jun 4, 2003
81
US
I have created a several page form with protected form fields. Upon entry of several fields a form will open for user entry. My problem is that I had set the code to unprotect the document and input the data into the document and then reprotect. The problem is, once you unprotect and then reprotect, all the data entered previously is lost. Is there a way to have the form field updated from this macro without unprotecting the document. If I remove the unprotect code, I get an error message saying the field is protected.
 
Please ignore this post. By using formFields result versus value I was able to make the code work.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top