自动化日程表2种模式表

1.C5录入日程标题,用于生成日程表后的标题,2.F5选择日程表样式,2种可选择,3.C9选择年份,F9选择开始月份,4.B17开始录入日程记录,B列可标记颜色,用于日程生成后记录颜色,必看：此模板为宏模板，若下载不能启用宏。可下载插件启用。插件安装后，重新下载打开模板即可正常使用。插件下载地址:https://pan.baidu.com/s/11AUFBYgjQKKMrGHcYOoKuw,日程表管理工具,XX公司日程表标题日历(列表)日程样式,2018.0年1.0月,日程表,颜色类型开始日期结束日期事件,43101.043105.0上海座谈会,43108.043110.0北京座谈会,43132.043133.0天津洽谈,43132.043137.0股东大会,出差43141.043147.0南开学术研讨,出差43148.043151.0XX公司考察,日程表管理工具,月份和星期设置,月份星期,1月星期日,2月星期一,3月星期二,4月星期三,5月星期四,6月星期五,7月星期六,8月,9月,10月,11月,12月,ANNUAL (TRADITIONAL & PLANNING) FORMATS,Font & Background ColorsFont Only,Week NumbersMonth Names,Weekday / Header LabelsLegendIf YES, Week numbers will be included on the TRADITIONAL format,Weekend DaysRegular Days,Import Completed Tasks (Tasks only),Import Tasks without Start / Due dates (Tasks only),Import Contact info (Protected by Outlook, user will need to grant permission),Imported Events Color,Category for Outlook Events (leave Blank to use standard ones),Start OnlyImport Outlook Appointment Hours into Event Labels,Sub/Shared Folder name (secondary Calendar or Tasks List) name - If empty, the main Calendar / Task List is imported,Shared Task List are not supported (Only calendars),Define Global Formatting for the Output Calendar Plan,Include Excel Default Gridlines on the Output Calendar Plan,星期一Start of Week (only applies to Traditional and Monthly output formats),dd/mmDate Format for Day's LEGEND,Apply Color to Weekend CellsCopy the "INPUT" sheet Header & Footer (printer) to the Output Calendars,Automatic Holiday Settings,Automatic Holidays Events Color,假日Category for Automatic Holiday Events,MONTHLY & MONTHLY (LIST) FORMATS,Border, Fonts & Background ColorsRegular Days FontChange the Background color and Font of each identified Cell, to customize the corresponding Calendar area.,MediumBorder ThicknessMonth Title Font,May not apply to all calendars.,Weekday / Header LabelsLegend FontAnnual formats have their own CONFIG Settings (Above),Weekend Days BackgroundDay Numbers (Monthly only) Font,Use Event color on Label0.0Max number of Characters for Event Labels (0 for no limit),TABLE FORMAT ,Fonts & Background ColorsFont Only,100.0Column Width (Days)Title Font,Month Names & Day NumbersLegend Font,Weekend Days BackgroundRegular Days Font,Use Event color99.0Max number of Characters for Event Labels (0 for no limit),MAIN_TITLE,MAIN_ENDCalendar Generation Finished.