Updating VBA code without replacing the entire workbook.

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

Create an addin (xlam) instead. That will contain only the code. The data can then be stored in a normal xlsx file. There's lots of info about creating addins on the web, for example https://trumpexcel.com/excel-add-in/

If it's a one off you could use something like to to import the updated modules

https://www.rondebruin.nl/win/s9/win002.htm