Solved: Unwanted Connection to Macros in Another WB
I have a workbook that contains code that somehow creates a connection to other workbooks I have open at the time.
When I close this workbook, the remaining open workbook tries to open the now closed workbook with a Sheet_SelectionChange event in the open workbook.
The only way to "kill" the connection is to close Excel entirely. Its like the macro is loaded into the application memory and won't let go, just runs on whatever else is open when a triggering event occurs.
I've tried making the subs private, modules private, etc. and that doesn't work either.
Any ideas?
Ron