How to deploy updates to the VBA for a workbook

[ev77]

I have a set of macros and userforms that I have created for a workbook. Users now using the workbook each have their own set of data (worksheets which are operated on by the VBA code & userforms).

I need to update the code & change the userforms a little. How can I save only the code and user forms from my workbook and send the it to the users so they can easily replace the old macros and userforms with the new ones?

Asking them to import a whole bunch of files (modules, userforms and code in individual worksheets) is not really a viable option.

Thanks so much for any help.

[bulina2k]

I've kinda was in your situation (except the userforms update), but for the code update I put on the Open event of the users the following code (modified):

Please Login or Register  to view this content.

so each time the user file is opened it gets the last version of code from last_version_code.txt
tell me what you think...