Plánovací kalendář

As a production planner, I don't rely on form distributors and I created this tool. The macro contained in the file automatically creates a planning calendar for the selected calendar year. The calculation includes highlighting public holidays, Easter and planned company-wide holidays.

All settings (font types, font formats, colors of each day type, header and footer text, etc.) can be manually set to your own requirements before running the macro. The created calendar is then optionally saved as a new sheet file or as a new file. In addition to the standard planning calendar, it is also possible to create a special line calendar, which can be used, for example, to record individual holidays of subordinate employees, holidays of suppliers, etc.