22 November 2017: Hi folks! Thanks to everyone who's downloaded and enjoyed my year planner macro over the years. I have had reports that the macro does not work under Office 2016 which until now I have not been able to test. As I write, the macro (V4.1) works unchanged on a new Office 365 install on a Mac. However if you have another workbook open it will fail with a 'Subscript out of range' error. I promise to fix this in the near future! So, close all other open workbooks and try again.
This update streamlines the Control Panel dialog, but more importantly introduces a new feature: split years. So if you begin a chart in June, it'll run to May the following year.
I've included a security disclaimer/guide for those struggling to get it to run under Excels' default macro security settings (tip: you need to turn security off).