Using a Master Sheet to update code on multiple workbooks

[UMAKEMESIK]

We use an excel form with tons of code in it. The sheet performs many tasks as needed. Everyone her has a copy of the form on their desktop. When I make changes to the code when I am upgrading I have to do a mass distribution of the newly revised form and ask all to delete previous used versions.

Can I have one master sheet on a public server that i will update the code on and the users will have their from on their desktop that will call to the master sheet for the visual basic code. This way I never have to re-distribute the form to all users. All i have to do is update the master sheet on the server and the users sheet will use the latest code on that sheet.

This is like CSS Cascading Style Sheets in Web page building. You produce one master sheet and all other pages use the CSS for its instructions on formating.

Any Ideas would be appreciated.

 

[ChrisM]

Can't give specifics, but you should be able to do this via "automating the VBE". Do some searches on that term and it should point you in the right direction.

Big note, if you have password protected the VBE module then I don't think you can do it.

I imagine you would institute a version system in a hidden sheet in everyone's workbook. They click a button and the macro queries your master copy and pulls its version number, then it compares versions, if theirs is old, then it kicks off the copy-replace routine.