VBA - Secured Signature cell --> Error / not working properly

Hello,

I am an intern at a company in Holland and as a part of my assignment i am trying to digitalise our Research & Development Timesheet.
At the moment there is an Excel Document which the personnel fills in.
The document is connected to another Excel document at the administration. This is a summary which is used to receive subsidy and tax reduction from the government.

At the moment the personnel needs to print the sheet and let a manager set a signature. the print goes to the administration and they check if the data from the print match the data in the summary.

my task is to find a way to secure the cell in Excel where the signature of one of the managers needs to be. when this signature is placed the timesheet of that week will close. the personnel cannot fil it in anymore.

I have almost 0 coding experience. i understand most of it when i read it. but i cant create it myself.

i have been getting some help from locals. this is what i have so far.
(it was in dutch) i tried to translate as much as possible without infecting the code).

Timesheet R&D.xlsm

PASSWORDS:

VBA - 111
signature - 123


i deleted al the weeks except one. to keep it short.






The problems that remain are:


1. i want the manager to be able to delete the signature for when personnel needs to change data in the timesheet.
2. Cell 33 <-- the signature cell can stil be filled in without a signature. because the workpage wil only be secured after the signature is placed. and even after that u can stil try to fil it in with succes.
3. Excel gives an error when the password for the signature is wrong. it can redirect the user to VBA code. the user should not be able to get inside the code , nor get a error.


I hope my story is clear.

Does anyone have any solutions for me?

Thank you.