Thread: Delete sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Delete sheets

Right click sheet tab of listview codeinsert this.

Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)
On Error GoTo nosheet
Application.DisplayAlerts = False
Sheets(CStr(Target)).Delete
Application.DisplayAlerts = True
nosheet:
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dias" wrote in message
...
Hi !
How can i delete sheets select name in list ?
I have a list of countries each one has a sheet with is name.
Wat i want is a code that wen i select one of those countries in the list
i can delete that sheet.
Sorry my English
Regards
Horacio