Hi Sam,

Precede the code with

Application.DisplayAlerts = False

and reset to true afterwards

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Sam" wrote in message
...
I don't see this option in saveas. Is there another way to avoid the
overwite dialog box when overwriting a file with a macro?
Thanks