I have a workbook with macros that are used to process the
contents of other workbooks.

I need a test to ensure that when i run the macros the
active sheet belongs to a workbook other than the one with
the macros.

I don't know how. Any suggestions?