Thank you all for your help. It appers that the workbook/s the macro is
opening are very heavily locked down, have made the necessary alterations and
now works fine.
--
with kind regards

Spike


"Alan McQuaid via OfficeKB.com" wrote:

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