It's the other way round:
ThisWorkbook refers to the workbook containing the code; ActiveWorkbook is the one with the focus.