lorcanjc Wrote:
I have tried using the displaymessages=false
but the fiule does not save correctly now any suggestions


Should that not be

Application.DisplayAlerts = False ??

Is this what you have coded ?
If so and it is still a problem then please post you code

--
Ivan F Moal

-----------------------------------------------------------------------
Ivan F Moala's Profile: http://www.excelforum.com/member.php...nfo&userid=195
View this thread: http://www.excelforum.com/showthread.php?threadid=26810