Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thank you Mike, this worked great and did not give me any pop up messages
about permanently deleting sheets. -- Thank you, Jodie "Mike" wrote: Try this Sub deleteSheets() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets With Application .DisplayAlerts = False With ws If .Name = "PLANID" Or .Name = "FEETOTAL" Then .Delete End If End With .DisplayAlerts = True End With Next End Sub "Jodie" wrote: How can I delete sheets with the names PLANID or FEETOTAL through VBA? -- Thank you, Jodie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming |