I am able to open excel in 2 separate instances, but whenever I run a macro in one spreadsheet, first of all it lists the macro available on the 2nd sheet as well (which is probably a part of my problem since it shows that the macro tool is only run once for both instances?), but most importantly once I start to execute the macro on the first spreadsheet (and until that macro is done), I can no longer work on the 2nd spreadsheet, much less start the macro on the 2nd spreadsheet...

Is there a way to run macros separately and independently on both spreadsheets at once? (short of logging in to multiple windows users at once I guess).