How to properly write Excel macros for other people

Question

I recently started writing VBA macros, even though I never learned VBA. So basically I am translating my python knowledge to VBA, which works most of the time. However I want to improve my coding skills, especially when it comes to working with other people.

Usually I am writing a Macro and then install it on the computer of my colleagues, so that they can use it as well. But the way we develope the macro is currently a try-and-error approach, so I have to edit the code quite often. Currently I just copy paste the new lines into an Email and the person has to exchange that line by themselves.

My Question: How do professionals handle updating VBA Macros? Is there something like "patches"? Or can you have a shared "Personal.xlsb", so that all changes are automatically updated for everyone else as well? I am the only person editing the code anyway, the others just use it.

I googled a lot and also looked through stackoverflow, but only found this: How to write a patch to Excel VBA codes? where the answer basically was, that you can't write patches. But there surely must be a way, to update my macros in a better way, right?

Thanks in advance!