Deleting Worksheet - No Confirmations ?
Lance
Precede the code with
Application.DisplayAlerts = False
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
wrote in message
...
How do I delete a worksheet without getting the confirmation message:
"Are you sure you wish to delete this worksheet?"
Application.ActiveWorkbook.Sheets(3).Delete
Lance
|