Change year Work planner with weekly calculation of the hourly difference Excel VBA

https://excel.hpage.com/work-planner-...
   • Work planner with weekly calculation of th...  
https://excel.hpage.com/create-progra...


Before the year or after the year you should delete the database with all calendar week hours using the “Delete hours in the year” button and also delete the database with weekly plans using the “Delete all weekly plans” button. The password for deletion is the number 3.

With the button "Change year" in the program a calendar for selected
Create a year with floating and fixed holidays. The user determines the number and names of the fixed holidays. A maximum of 15 fixed public holidays can be assigned. The program has a list of 16 moveable holidays. Tick the checkbox of public holidays.
Click on the "Enter" button, enter a four-digit year in the input field and click on "OK". The calendar is created.

The public holidays have a red background color in the calendar.