如何避免在错误的工作簿中执行VBA功能

I have several excel files that have timer and macros executing. But a big problem is when workbook A's macro is called, while workbook B is active. The macro is executed in the wrong book and failed.I have several excel files that have timer and