I have a standard form which I want users to fill in, but I don?t want users to modify the data that is already on the form. The form will prompt the user for information that is required to be entered when the form is opened. I also want to have adrop down list for names that users can select from.
I have created the form using the Ask field and created an AutoOpen macro to open and prompt the user for the required information when the document is opened. That works really well. But canI protect the data on the form from being modified and at the same time allow users to use the drop down list as well. I have tried to use section breaks and then protected the sections that I didn?t want modified, but this doesn?t work, as the macro won?t run if the form is locked. Anyone have any suggestions as to what I can do?