I have a few workbooks containing thousands of lines of code that I have distributed to my organization. All of the workbooks contain user forms through which various people within my organization are able to manipulate data (this includes loading data from outside the immediate workbook). However, whenever I make changes/updates to the VBA code, I either have to

1) export the data from the existing file, copy the new file to the directory, then import it into the new file with the updated code, or
2) manually copy the code into the existing file

Is there an easy way to update VBA code in a workbook without changing anything else whatsoever, as if I were simply updating a piece of software?

Thanks