I have a workbook (WorkBookA) with about 30 sheets in it.
It is created by an external piece of software.
I have an existing workbook which "Stores" macros (WorkBookB).
One of the Macros in WorkbookB sorts the sheets in alpha order. (I want this to happen in WorkbookA NOT WorkBookB)
Problem: When I run the "SortSheets" macro it sorts the sheets in WorkBookB. How do I force it to sort the sheets in WorkBookA.