View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Philip[_6_] Philip[_6_] is offline
external usenet poster
 
Posts: 9
Default Calling the wrong macro

Hi Folks,
Any help with this would be much appreciated:
I have two workbooks created in Excel 2000, Book A and Book B
Both work books contain a macro which have the same name: MyMacro1

MyMacro1 contains different code in each workbook
When I call MyMacro1 in Book A, Excel opens Workbook B and runs the code
within the Book B - MyMacro1

I can't figure out why this happening - has anyone any ideas please?
I've tried deleting both macros and recreating them independently - to no
avail!

TIA

Philip