Hi,

A macro I use deletes a sheet tab, however, it prompts me to confirm
the deletion of the sheet. How can I remove this prompt so the macro
runs without any user interaction?

Matt

I think you can use this:

Sub delSheet()

Application.DisplayAlerts = False
Application.Sheets(1).Delete

End Sub


--
urkec


"Guerilla" wrote:

>
> Hi,
>
> A macro I use deletes a sheet tab, however, it prompts me to confirm
> the deletion of the sheet. How can I remove this prompt so the macro
> runs without any user interaction?
>
> Matt
>
>

Add these 2 lines to your macro:

Application.Displayalerts = False '<<<< here
worksheets("TempData").Delete
Application.Displayalerts = True ' <<< and here

HTH

"Guerilla" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed):

> Hi,
>
> A macro I use deletes a sheet tab, however, it prompts me to confirm
> the deletion of the sheet. How can I remove this prompt so the macro
> runs without any user interaction?
>
> Matt

Both answers worked, thank you very much.

Matt