Hi Spike,

It's possible that one of the workbooks has an Open/Close event macro in its
workbook module.

Try inserting the below messages above and below your ActiveWorkbook.close
line

Application.EnableEvents = False ' Stops any Auto events from running on
other macro workbooks
Activeworkbook.close savechanges:=false
Application.EnableEvents = True ' Re-enables the events

Alan

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200905/1