That line that I've put in the previous message is in the 'Before_Save'
macro,
it is triggered by a line in the Before_Close macro that reads:
ThisWorkbook.Save