Work planner with weekly calculation of the hourly difference Excel VBA

The Excel file in the program has 2 sheets: Mask and Sheet. In this program everything is entered via an input mask.
The input mask is activated on the Mask worksheet using the Mask button. There are three yellow buttons in the input mask. The Legend button opens the Legend frame.
You can enter up to 100 designations and abbreviationscodes in the Absent due to and Workplace fields.
For Department you can enter a total of 20 designations. The Employee database button opens the Employee database frame.
In this framework you can enter 100 employees for each department.
The records must not contain the number of contractually agreed hours per week.
You can insert or remove an image for each employee. The Work planner_Weekly planner button opens the Work planner_Weekly planner frame.
Entries in the weekly planner are only possible if the month date week department and personnel number are selected. In the program you can record up to 10 periods in a working day for each employee.
For example an employee works 12 hours a day.
In the first hour he will do one job then he will do other work and in this way you can record up to 9 work changes per working day. You can create entries for each calendar week from Monday to Sunday.
It doesnt matter whether the week falls in the middle of the month or is divided into two months. The hours entered minus the breaks are added up for the entire week the contractual weekly working hours are deducted from the total amount and the difference is calculated. For days on which the employee did not work due to vacation illness or other reasons an abbreviation of the reason is entered Hours are not entered in this case. Every incorrect entry is deleted at the push of a button. The Change year button creates a calendar in the program for the selected year with moving and fixed holidays. Für Tage an denen der Arbeitnehmer aufgrund von Urlaub Krankheit oder anderen Gründen nicht gearbeitet hat wird eine Abkürzung des Grundes eingetragen Stunden werden in diesem Fall nicht eingetragen. Jeder fehlerhafter Eintrag wird per Knopfdruck gelöscht. Mit der Schaltfläche Jahr wechseln wird in dem Programm ein Kalender für ausgewähltes Jahr mit beweglichen und festen Feiertagen erstellt.