View Single Post
 
Old 07-31-2013, 10:36 AM
jec1 jec1 is offline Mac OS X Office 2010 32bit
Advanced Beginner
 
Join Date: Jan 2012
Posts: 84
jec1 is on a distinguished road
Default Calendar Template

Hi Derricks

Just rename files (delete .zip extension).

I've created a 10 month calendar. The document xxxNotes.dotm has a few notes and some screenshots. The other document is a clean template. I have created one calendar build only for 10 months - you can change months and years but not 12 Months Start Sunday because that's the Quick Parts Table I've used in Event Planner Category attached to your template. I have not created the other 3 options (there are 4 quick part tables altogether) in original template:

12 Months Start Monday
12 Months Start Sunday
6 Months Start Monday
6 Months Start Sunday

I haven't altered macro just worked with it.

If you require the other tables you will have to build them first from the original template - it is quite a PITA. Layer 1 quick table building block actually goes on top of the table layout layer.

To use the template do File New (creates a new document) and make your edits - obviously edit your .dotm template first to get your template looking as you wish.

Feel free to ask anymore questions - hopefully you will get the gist of how the template macro works. It inserts one of the 4 quick part tables into the template when you request the specific options in the userform. You only have 1 table so you cannot alter your selection as per the screenshot. You can select new years and start month. Your calendar is 10 months.

Kind regards
janinecrutch.com
Attached Files
File Type: zip Corporate Engagement Calendar Notes.dotm.zip (264.8 KB, 12 views)
File Type: zip Corporate Engagement Calendar v1.dotm.zip (138.6 KB, 15 views)

Last edited by jec1; 07-31-2013 at 06:44 PM.
Reply With Quote