Macro para eliminar hojas exceptuando la hoja activa
Código:
Dim ws As Worksheet
ForEach ws In ThisWorkbook.Worksheets
If ws.Name <> ThisWorkbook.ActiveSheet.Name Then
Application.DisplayAlerts =False
ws.Delete
Application.DisplayAlerts =TrueEndIfNext ws
EndSub