Hi,
I'd like to delete a worksheet silently, but Excel asks for a confirmation,
because the sheet is possibly not empty. I tried to clear or delete its
usedrange beforehand, but it doesn't work neither (still asks for
confirmation).
My question: How to bypass this automatic request. By the way, I don't
understand that in the VB editor, "delete", the "d" is written in lowercase.
Thanks in advance.
--
Jean-Pierre Bidon
Interstat
91 rue de Rennes
75006 Paris
Tél: 01 45 49 19 17

Bonjour Jean-Pierre

Application.DisplayAlerts = False
Worksheets(1).Delete
Application.DisplayAlerts = True

the lowercase d indicates a problem. Maybe a procedure, a variable or a
control is named "delete". If so then rename it, the word has a reserved
special meaning.

HTH. Best wishes Harald

"Jean-Pierre Bidon" skrev i melding
...
Hi,
I'd like to delete a worksheet silently, but Excel asks for a
confirmation, because the sheet is possibly not empty. I tried to clear or
delete its usedrange beforehand, but it doesn't work neither (still asks
for confirmation).
My question: How to bypass this automatic request. By the way, I don't
understand that in the VB editor, "delete", the "d" is written in
lowercase.
Thanks in advance.
--
Jean-Pierre Bidon
Interstat
91 rue de Rennes
75006 Paris
Tél: 01 45 49 19 17

Hi Jean-Pierre,

Try:

Application.DisplayAlerts = False
Sheets("Your Sheet Name").Delete
Application.DisplayAlerts = True

---
Regards,
Norman



"Jean-Pierre Bidon" wrote in message
...
Hi,
I'd like to delete a worksheet silently, but Excel asks for a
confirmation, because the sheet is possibly not empty. I tried to clear or
delete its usedrange beforehand, but it doesn't work neither (still asks
for confirmation).
My question: How to bypass this automatic request. By the way, I don't
understand that in the VB editor, "delete", the "d" is written in
lowercase.
Thanks in advance.
--
Jean-Pierre Bidon
Interstat
91 rue de Rennes
75006 Paris
Tél: 01 45 49 19 17

Sub DeleteSheet ()
If Worksheets.Count 1 Then
Application.DisplayAlerts = False
Sheet1.Delete
Application.DisplayAlerts = True
Else
Msgbox("You can't delete the last Sheet!")
Exit Sub
End If
End Sub

A lowercase keyword usually means it is not recognized as belonging to the
object with which it is being used. If the command works as intended, then I
am not sure.

Mike F



"Jean-Pierre Bidon" wrote in message
...
Hi,
I'd like to delete a worksheet silently, but Excel asks for a
confirmation, because the sheet is possibly not empty. I tried to clear or
delete its usedrange beforehand, but it doesn't work neither (still asks
for confirmation).
My question: How to bypass this automatic request. By the way, I don't
understand that in the VB editor, "delete", the "d" is written in
lowercase.
Thanks in advance.
--
Jean-Pierre Bidon
Interstat
91 rue de Rennes
75006 Paris
Tél: 01 45 49 19 17