TheRedCardinal
Board Regular
- Joined
- Jul 11, 2019
- Messages
- 243
- Office Version
- 365
- 2021
- Platform
- Windows
I have a set up like this:
The update comes from a Workbook_Open sub in the ThisWorkbook module.
Now I went to update the ThisWorkbook subs centrally as well. I have a ThisWorkbook .cls file in the same central repository.
But I'm running into problems with basically trying to update the ThisWorkbook subs from a sub contained therein.
Is there a way to do this from within the ThisWorkbook Open_Sub routine (there are other routines to import as well), or do I need to write a new workbook which basically pushes the update out to the files?
- 1 Central Maintained Control Spreadsheet
- Several (10+) specific and customised Workbook
The update comes from a Workbook_Open sub in the ThisWorkbook module.
Now I went to update the ThisWorkbook subs centrally as well. I have a ThisWorkbook .cls file in the same central repository.
But I'm running into problems with basically trying to update the ThisWorkbook subs from a sub contained therein.
Is there a way to do this from within the ThisWorkbook Open_Sub routine (there are other routines to import as well), or do I need to write a new workbook which basically pushes the update out to the files?