Disable "Are you sure you want to overwrite worksheet&q

[ificouldpaint]

Hi everyone,
I'm in a bit of a pickle, I have VBA code adding a new workbook which then uses the SaveAs method to overwrite an existing workbook. This throws the standard alert up on screen which says "Are you sure you want to overwrite worksheet" or something along those lines. I need this to be disabled.

Looking at the displayalerts property this isn't going to be possible.

Does anyone know how this can be done.

Regards

Ificouldpaint

 

[Peter_SSs]

Re: Disable "Are you sure you want to overwrite workshe

Looking at the displayalerts property this isn't going to be possible.

Why not?

Doesn't this do what you want?
Application.DisplayAlerts = False
Your code here
Application.DisplayAlerts = True

 

[Richard Schollar]

As Peter says, you can disable the alerts purely for the WorkbookSaveAs command, and then turn it back on again for the rest of your code.

Richard

 

[ificouldpaint]

Sorry just saw an article on Microsoft which clarified

Sorry just saw an article on Microsoft which clarified the help file in excel.

Apparently application.DisplayAlerts = False will disables the error box for file overwrite.


This extract from the help file confused me... however it does actually make sense.

When using the SaveAs method for workbooks to overwrite an existing file, the 'Overwrite' alert has a default of 'No', while the 'Yes' response is selected by Excel when the DisplayAlerts property is set equal to True.

Regards

Ificouldpaint