Change year Flexible shift planner and duty planner in Excel VBA

https://excel.hpage.com/flexible-shift-planner-and-duty-planner-in-excel-vba.html
https://www.youtube.com/watch?v=IZ8GUurIj5o&list=PLcwMjDfa1J1_fWNdxHh9Ahvdy3R73hWW0
https://excel.hpage.com/create-programs-in-excel-vba-itself.html

Before changing the year or after changing the year, you should use the "Delete database" button to delete all the data collected in the database. Password for delete is the number 3.

The "Change year" button will create a calendar for the selected year with floating and fixed holidays in the program. 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 moving holidays. Tick the checkbox of public holidays.

Click on the "Take over" button, enter a four-digit year in the input field and click on "OK". The calendar is created.

Public holidays have a red background color in the calendar.

Видео Change year Flexible shift planner and duty planner in Excel VBA канала excelgeist