Thread: Complete Delete
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pfsardella@yahoo.com.nospam is offline
external usenet poster
 
Posts: 172
Default Complete Delete

Application.DisplayAlerts = False
Sheets(Array("Comments", "Dispersion", "BOPSummary", _
"EOPSummary")).Delete
Application.DisplayAlerts = True

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

I have a macro which recorded me selecting sheets, then, I record the right
click and hit delete. Then I hit the delete button, but I don't see that it
records anything when I confirm the delete, by hitting the delete button.
How do I tell the macro to confirm the delete operation. Here is the macro
I recorded.

Sheets("Comments").Select
ActiveWindow.ScrollWorkbookTabs Position:=xlLast
Sheets(Array("Comments", "Dispersion", "BOPSummary",
"EOPSummary")).Select
Sheets("EOPSummary").Activate
ActiveWindow.SelectedSheets.Delete