Form and protection

D

djExcel

I have a protected form which has few text form fields. I also have a macro,
which adds new paragraph if needed. In order to work, this macro has to
unprotect document (and protect again when paragraph is added). Now, if user
has entered text in text form fields and runs the macro after that, then all
fields are cleared. Is there a way to keep those texts?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Paragraph numbering in Word 1
Clearing Fields in a Word Form 5
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Need help modifying code 0
Manual or Automatic Paragraph Spacing? 2

Top