Locking Documents and Drop-Down Lists

macropod · #1 11-04-2012, 02:53 AM

Hi Andrew,

Forms protection with formfields is required by design. In part it's so the user can't makes edits other than what the designer intends/allows - including deleting the formfields. On-entry and on-exit macros will only run when the document is protected.

If you want to allow free text entry somewhere else in the document, insert Section breaks before & after that portion, then leave that Section unprotected when you apply the forms protection.

Andrew H · #2 11-04-2012, 02:59 PM

Quote:

Originally Posted by macropod

Hi Andrew,

Forms protection with formfields is required by design. In part it's so the user can't makes edits other than what the designer intends/allows - including deleting the formfields.

OK - makes sense.

Quote:

Originally Posted by macropod

On-entry and on-exit macros will only run when the document is protected.

OK, that news to me, but thanks: that explains why my macro would not run.

Quote:

Originally Posted by macropod

If you want to allow free text entry somewhere else in the document, insert Section breaks before & after that portion, then leave that Section unprotected when you apply the forms protection.

Thanks, but this does not solve my problem. And the reason is this: I need to be able to have "locked" fields and "unlocked" text in the same line. It appears that I cannot insert section breaks "inside" a given line.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Drop-down lists in Excel	Maureen	Excel	1	11-10-2011 08:11 AM
Dependent drop down lists in Word 2007	benbenasc	Word VBA	0	08-24-2011 06:34 AM
Ho to perform multi selection in drop down lists?	nashville	Word	0	09-29-2010 07:10 AM
Using both drop down lists and blank cells for text	voltarei	Word	0	03-18-2010 04:16 AM
Drop Down Lists	Browett	Excel	0	12-19-2005 04:20 PM