Quote:
Originally Posted by macropod
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.
|
=============================================
Can I bother you to make that alteration so that the network issue goes away - so keeping both docs in one file will work?
Thank you.
Next, I've attached a new version of the lesson plan.
There are two cells - each with a green box with an arrow.
One at the end of the Date - Grade - Notes line.
The other at the end of the Gifted Domains - Gifted Standards line.
Is it possible to turn those two green cells into a "button" of some kind which, when clicked or selected, will create an additional row of cells beneath the existing row?
ideally, when making the lesson plan, I'll be able to click on the green arrow cell and another row will show up so I can select another Gifted Domain and Gifted Standard.
Is that possible?
Thanks,
dede