View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Deleting Worksheet - No Confirmations ?

Application.DisplayAlerts = False
Application.ActiveWorkbook.Sheets(3).Delete
Application.DisplayAlerts = True

--

Regards,

Peo Sjoblom

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