Delete sheets
 

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

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