Is it possible to have multiple workbooks use the code in a single VBA module?
I have 18 workbooks that all have identical code behind them. When I need to make a change, I make it in one, the copy the completed code to each of the other workbooks, replacing the old code.
It sure would be easier to reference an external .bas file, or automatically suck it in before it's used.
I've tried to figure this out off and on for a year, but now the number of workbooks is growing and it's becoming more important to figure out.
I'm in Excel 97 on NT 4 (soon to move to 2002 on XP).
I have 18 workbooks that all have identical code behind them. When I need to make a change, I make it in one, the copy the completed code to each of the other workbooks, replacing the old code.
It sure would be easier to reference an external .bas file, or automatically suck it in before it's used.
I've tried to figure this out off and on for a year, but now the number of workbooks is growing and it's becoming more important to figure out.
I'm in Excel 97 on NT 4 (soon to move to 2002 on XP).