Macro runs while in focus of targeted workbook but out-of-range once I change of wb

Hey,

I've been lurking the forums and the web but have yet to find how to solve this..
The code as it stands looks like this, in a module:

Please Login or Register  to view this content.

This works as long as my MarketTracker.xlsm/MarketTrack(sheet) is in focus, though as-soon-as I change of workbook it throws me an error "out-of-range" (I'm assuming it's because the macro is trying to run the My_Procedure but it's no longer in the right place...) That said, all my workbooks (excel-files) are open at all times.

Is there a way to get the Macro to always run on a specific workbook/worksheet in the background?

Thanks for your time!