Sub nomsOnglets()
For Each sh In ThisWorkbook.Worksheets
Sheets("Listing").Range("B" & i + 1) = sh.Name
i = i + 1
Next sh
End Sub
Sub liste()
Dim ws As Worksheet
For Each ws In Worksheets
Feuil1.Range("A65000").End(xlUp).Offset(1, 0) = ws.Name
Next ws
End Sub
Private Sub Worksheet_Activate()
[C1:C100].ClearContents
For i = 11 To Sheets.Count
nf = Sheets(i).Name
ActiveSheet.Hyperlinks.Add Anchor:=Cells(i - 5, 3), Address:="", SubAddress:="'" & _
nf & "'" & "!A1", TextToDisplay:=nf
Next i
End Sub