Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
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 |