VBA block warning
 

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

VBA block warning
 

Hi Kokki,

Try:

Application.DisplayAlerts = False

'your code to delete the sheet

Application.DisplayAlerts = True


---
Regards,
Norman


"kokki" wrote in message
...
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

VBA block warning
 

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" wrote in message
...
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