Two macros with same name in different workbooks
 

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.

Two macros with same name in different workbooks
 

As ALWAYS post YOUR code for comments. Try

with activeworkbook

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Pioneer1868" wrote in message
...
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.

Two macros with same name in different workbooks
 

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


"Pioneer1868" wrote in message
...
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.

Two macros with same name in different workbooks
 

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.


"Pioneer1868" wrote:

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.