Re: Network Location Issue & Sharing with Colleagues
If the template & workbook can be stored in the same folder, you (or I) could change this line in the code:
StrWkBkNm = "C:\Users\" & Environ("Username") & "\Documents\Master List of I Can Statements.xlsx"
to:
StrWkBkNm = "ThisDocument.Path & "\Master List of I Can Statements.xlsx"

That will address any Network Location & Sharing issues. Simply send colleagues both, with advice to keep them in the same folder.

To edit the template, simply use File|Open, choose the 'All Word templates' file type, then navigate to where your template is stored and select it.

Re: Number of Learning Target Lines & Number of Date & Grade Lines
Perhaps you could attach a document showing what you mean.

Re: Progress Description After I Can
Yes, that's possible, but it seems to me there is a more fundamental issue to be addressed: the standardisation of Progress Descriptors. In any event, if you distribute the workbook and don't protect it, anyone can change the Progress Descriptions there.

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