I now see what you meant byFixed.

I've also added the code to prevent LearningTargets 2-5 until something is selected from the previous LearningTarget.

The attached template contains none of the workbook data - which is how you'd normally store such a template. Double-clicking on it should create a new document with the data.

I have retained the code that works with your original workbook structure; I see no advantage in changing it. That said, I'm not sure what you mean by:
Do you mean that, if you choose Knowledge, the choices that become available are all of the entries on that sheet? If so, you could only choose one of those 30-40 entries, whereas the current process allows you to output all that are applicable to Distinguished, for example, and gives you the ability to delete any you don't want and/or to re-word the ones that are there.

Attached Files

Lesson Plan MASTER.dotm (51.6 KB, 18 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]