Two macros with same name in different workbooks

[Pioneer1868]

I have two workbooks with a set of macros with the same names in each.
However the macros are not identical. When I attempt to execute macro "A" in
workbook "A", Excel executes macro "A" from workbook "B" which creates
problems. How can I direct Excel to the specific version of the macro I want
to use?

Thanks!

Excel version 2007 running on Windows 7.

 

[Don Guillett]

As ALWAYS post YOUR code for comments. Try

with activeworkbook

 

[JLGWhiz]

Also, is there a reason why one of the macro names cannot be modified?

 

[Aussie Bob C]

Add the number 2 onto the end of Workbook B macro's.
The macro's are different so name them differently.

--
Thank you

Aussie Bob C
Little cost to carry knowledge with you.
Win XP P3 Office 2007 on Mini Mac using VMware.