As per another thread, I am having all sorts of problems getting a macro to run "on exit" from a drop-down list.

I think there is a fundamental issue that I need some help on. In order for a drop-down list to be "active", the document must be in a protected state. So I ensure my document is in a protected state when the document is provided to a user (who will use the drop-down). Fine.


Now suppose I want the macro to insert text "on exit". Well, presumably I have to unprotect the document to do this. Don't I need to therefore insert this line of VBA code in the macro?:

ActiveDocument.Unprotect

When I do this, I still do not get success - when the user makes a selection, the document remains in a protected state and the text is not entered.