I want 2 modules to share macros

  • 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?

    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • 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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!