Excel / VBA workbook.activesheet返回错误的工作表

I have a workbook (we'll call it "AAA") that is based on a template and refers to code modules in a second workbook. The second workbook (we'll call it "CodeStorage") is a repository for code modules so that any saved versions of the template will be able to access modified/updates code without a change to the saved workbook.I have a workbook (we'll call it "AAA") that is