Option Explicit
Private Sub Workbook_SheetBeforeDoubleClick(ByVal o As Object, ByVal Target As Range, Cancel As Boolean)
Dim Plage As Range
Cancel = True
If o.Name <> "a" And o.Name <> "b" Then ' noms des onglets adapter
Set Plage = Union(Range("L10:L11"), Range("L13:L14"))
If Not Intersect(Target, Plage) Is Nothing Then UserForm1.Show
End If
End Sub