B
Bill
I have a form that I saved as a template, so that I can insert it into
various documents. I have written code that inserts this form using a macro
that does that and also opens a userform. The form has bookmarks and form
fields with options and drop downs that only work when the form is protected.
I need the form unprotected so that I can insert information from the
userform into specific bookmarks, but then need it protected after that, so
the form field options and drop downs will work. Is there code I can run in
the userform when the form is inserted that will unprotect it until the
infomation is sent to the bookmarks, and then code I can run to protect the
form so the form field options and drop down will work when I exit the
userform, or do I have to manually open the toolbars from the [View]
[Toolbars] [Forms] menu? Thanks!
various documents. I have written code that inserts this form using a macro
that does that and also opens a userform. The form has bookmarks and form
fields with options and drop downs that only work when the form is protected.
I need the form unprotected so that I can insert information from the
userform into specific bookmarks, but then need it protected after that, so
the form field options and drop downs will work. Is there code I can run in
the userform when the form is inserted that will unprotect it until the
infomation is sent to the bookmarks, and then code I can run to protect the
form so the form field options and drop down will work when I exit the
userform, or do I have to manually open the toolbars from the [View]
[Toolbars] [Forms] menu? Thanks!