automatically deleting a worksheet (without warning prompt)
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
|