Excel runs a macro from the wrong workbook because it has the same name as the macro I'm trying to run

[JohnTopham]

Hi all,

I have two workbooks that are almost the same because they're from a master template workbook (I need both to be open at the same time). When I try to run a macro (Ex. Sub Calculate), it runs the Sub Calculate from the other workbook that is open. Is there a way to make sure it runs the one I want?

I want to avoid renaming every subroutine to be more specific.

Thanks

 

[Joe4]

Welcome to the Board!

Yes, you can usually create a workbook reference dynamically "capture" the references of each workbook, and refer to which one you want to run the code on.
Of course, you will need to explain how to distinguish the two and determine which one it should be running against.

Note. You also NEVER want to use reserved words like "Calculate" as the name of your procedures, custom functions, or variables (reserved words are the names of existing Excel functions, properties, methods, etc). It can cause ambiguity, confusion, errors, and unexpected behavior. I often preface the name of my procedures and variables with the word "My..." to make sure I don't do that.