Hi Anthony,

The saveas line is exactly the same as the save option in the project once
its running, but that works without any problems (although there is a slight
pause)

If I replace saveas with savecopy function its exactly the same.


Anyone with any ideas?

Try moving the save code to a sub in a normal module and calling the save sub
using Application.Ontime in the Open event.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com