I want 2 modules to share macros. They can all be in the same workbook. When I update code to the macros I only want to do it once, even though both modules use those macros.
Excel 2007, Windows 10
I want 2 modules to share macros. They can all be in the same workbook. When I update code to the macros I only want to do it once, even though both modules use those macros.
Excel 2007, Windows 10
And what is the problem you have doing that?
Actually, because you ask this question, I tried one and it works. I thought I would have to tell Excel where to find the subs. Hard to believe it is so easy!!! Of course I have to pass extra parameters, but that's ok. Thanks anyway.
Don’t have an account yet? Register yourself now and be a part of our community!