change / modify VBA code in other files on the network

[modytrane]

I have created a workbook that basically provides users with templates that they can populate and then create different types of summaries.
This was copied and given to fifteen users in our office. All of their workbooks are now unique with their own client information.
Everything works fine so far.

As they use the workbook, they are coming up with some suggestions and ideas. I had expected this anyway. But my problem is that every time I need to make a change I have to go to 15 seperate workbooks and make the chnage.

I already have macros that open these workbooks [one at a time], copy some data out of each book and create summaries for the office.

Can I create a macro in my master file that would remotely open these workbooks and modify or change VBA codes? The change would be same for all the books. Even if I could replace entire modules that would be fine.

VBA is password protected in these workbooks.

Any ideas or suggestions would be greatly appreciated.

There are a number of chnages pending to be implemented. It would be a great time saver if I can run a macro and make changes to all workbooks on the network.


Thanks,

modytrane

[royUK]

If the VBA code is protected in the other workbooks then you can't change the code using a macro. What you need to do is to move the code to an excel addin, stored on the network then update the addin