Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
When I close a workbook that has a custom add-in, a blank window (presumably VBA or add-in related) opens for a fraction of a second and then closes at the same time as the workbook. It's not a problem, more of an irritation that I don't want to see.
Both the workbook and custom add-in have a This Workbook module, but there's no code in the This Workbook module and there's no Close event code in the add-in This Workbook module, so I don't know what could be causing this.
It started happening when I entered "this workbook.save" in the Immediate window of the add-in, because code I'd amended previously wouldn't update. It saved the updated code OK but I've had this phantom window opening ever since.
Many thanks!
When I close a workbook that has a custom add-in, a blank window (presumably VBA or add-in related) opens for a fraction of a second and then closes at the same time as the workbook. It's not a problem, more of an irritation that I don't want to see.
Both the workbook and custom add-in have a This Workbook module, but there's no code in the This Workbook module and there's no Close event code in the add-in This Workbook module, so I don't know what could be causing this.
It started happening when I entered "this workbook.save" in the Immediate window of the add-in, because code I'd amended previously wouldn't update. It saved the updated code OK but I've had this phantom window opening ever since.
Many thanks!
