|
-
Sep 12th, 2010, 08:43 PM
#1
Thread Starter
Hyperactive Member
Macro ambiguity question
Is there a way to avoid ambiguity in running macros (subroutines) that have identical names in multiple open workbooks? To further explain, I have two macro enabled workbooks opened. Both have a VBA subroutine named "Test" that is executed by either a button click or a hot key. In some cases, when workbook 'A' is active and 'Test' is launched with a hot key, the 'Test' subroutine in workbook 'B' is executed instead. Is this an Excel problem? Is there a way that I can ensure that the subroutine associated with the active workbook is the one executed and not the 'inactive' one? Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|