Hello,
A couple of months ago I had a problem concerning a VBA form and Tsjallie helped me oud enormously, but now that I am using the form, or rather my colleagues are using it and I have encountered 2 small problems, which I hope can be remedied.
First of all as you see in the attachment, the last two entries on the "overzicht vormingen" sheet don't take over the data that's been input in the form, but rather they just take over the idnumber of the far left. This happens whenever you choose to uplift the protection of the sheet and then protect the sheet again. "edit post: I've just seen that every other person who opens this document (this document is on a server) and fills in the form also produces this problem.
Second of all, putting in the hours in the form. If people don't use the correct way "8:00:00" but instead just type "8". The result in the "overzicht vormingen" sheet is not what it should be. I could ask people to use the right way for notation, but I was wondering if there is a way to make sure that the "8" entries also get written down correctly.
The last problem I've experienced is that every person who uses this document (this document is placed on a server) first gets the "betrouwbaar document...." and "inhoud inschakelen" message. Some people get confused/scared by this and don't follow through. Is there a way to make this document immediately thrustworthy and the macro automatically enabled
Bookmarks