Supress Warning Message
 

I have the following code in a macro:

For i = numVars + 1 To 15
Sheets("numVar" & i).Select
ActiveSheet.Delete
Next

It automatically deletes some tabs in my workbook. Every time I run it I
get a warning message asking if I really want to delete each tab. Is there
any code I can place before I run this loop to supress these warning messages?

Thanks.
--
Regards,
Dave

Supress Warning Message
 

use this at the begning of your code

Application.DisplayAlerts = False



David Billigmeier wrote:
I have the following code in a macro:

For i = numVars + 1 To 15
Sheets("numVar" & i).Select
ActiveSheet.Delete
Next

It automatically deletes some tabs in my workbook. Every time I run it I
get a warning message asking if I really want to delete each tab. Is there
any code I can place before I run this loop to supress these warning messages?

Thanks.
--
Regards,
Dave

Supress Warning Message
 

Try this

Application.DisplayAlerts = False


"David Billigmeier" wrote:

I have the following code in a macro:

For i = numVars + 1 To 15
Sheets("numVar" & i).Select
ActiveSheet.Delete
Next

It automatically deletes some tabs in my workbook. Every time I run it I
get a warning message asking if I really want to delete each tab. Is there
any code I can place before I run this loop to supress these warning messages?

Thanks.
--
Regards,
Dave