VBA block warning

[kokki]

In VBA code I delete an existing worksheet.
while doing this a warning comes and questions if you wish to delete this
worksheet.

How can I make that this mesage does not appear?
thx.
--
kokki

[Norman Jones]

Hi Kokki,

Try:

Application.DisplayAlerts = False

'your code to delete the sheet

Application.DisplayAlerts = True


---
Regards,
Norman


"kokki" <[email protected]> wrote in message
news:[email protected]...
> In VBA code I delete an existing worksheet.
> while doing this a warning comes and questions if you wish to delete this
> worksheet.
>
> How can I make that this mesage does not appear?
> thx.
> --
> kokki

[kokki]

Hey Norman, thx it works.
--
kokki


"Norman Jones" wrote:

> Hi Kokki,
>
> Try:
>
> Application.DisplayAlerts = False
>
> 'your code to delete the sheet
>
> Application.DisplayAlerts = True
>
>
> ---
> Regards,
> Norman
>
>
> "kokki" <[email protected]> wrote in message
> news:[email protected]...
> > In VBA code I delete an existing worksheet.
> > while doing this a warning comes and questions if you wish to delete this
> > worksheet.
> >
> > How can I make that this mesage does not appear?
> > thx.
> > --
> > kokki
>
>
>