Automated removal of workbook_open macro

I currently have a considerable number of workbooks being used by several people in a number of locations.
Each of these workbooks has the same (reasonably complex) module attached.
This module is updated (when necessary) by the user setting a flag on a control sheet and then the next time the workbook opens, the old version of the code is removed and the new version is loaded.
This "code update" is handled (as I didn't know any other way at the time of writing it) by a workbook_open macro in each individual workbook.

Now to the problem.
I want to change the way this code update is handled so I need to alter the workbook_open of several hundred (probably) workbooks.
Does anyone have any idea how I could do this in an automated way?

I now have an "auto_open" sub in the module that is auto-updated.
Could I use this?

Can I use this to remove the workbook_open?

If I replaced the workbook_open with an extra bit in the auto_open, would the auto_open in the module allow that same module to be removed and then a new version added?

Hope I've explained it OK and thanks in advance for any suggestions.

Sorry for any confusion.
When i initially set this all up I used workbook_open to handle the automated updating of the module.
Since then I have (thanks largely to kind people in this forum) learned a lot and have recently added an auto_open sub to the module.

I now need to modify the workbook_open code so that it does some extra "stuff".
To do this I would need, as far as I know, have to modify each individual workbook (of which there are a great many).
My preferred option would be to remove the workbook_open from each workbook and use auto_open in the module instead (so that each time the module is "refreshed", so would the "open" code).

So, in a nutshell, the questions are ...

1. Can I use some automation (I'm guessing something in the module-based auto_open) to remove the workbook_open code from the workbooks.

2. Can I use an auto_open in module A to remove and then import module A.

Hope I've explained it better (and thanks for your help).

Latest version of module is stored in a .BAS file on the LAN.

Currently, workbook_open detects request for "refresh" of code from a cell on each workbook being set to "Y" then removes the module from the workbook and then imports it from the LAN.

In case it helps, code currently in workbook_open is ...

Please Login or Register  to view this content.

Thanks very much for your help Leith.
Yep - that's a good option.
What about the potential problem (in my head) of the auto_open being IN the module that is being removed and then imported?
Would that work?