Bonjour,
Pour le principe
Option Explicit
Private Sub Workbook_Open()
Sommaire
End Sub
Option Explicit
Option Private Module
Public Sub Sommaire()
Dim ws As Worksheet, i As Integer, tmp As String
Application.ScreenUpdating = False
Set ws = Worksheets("Accueil")
With ws
.Cells.Clear
.[A1] = "Sommaire"
.[A2].Select
For i = 2 To Worksheets.Count
tmp = CStr(Sheets(i).Name)
.Hyperlinks.Add _
Anchor:=Selection, _
Address:="", SubAddress:="'" & tmp & "'" & "!A1", _
TextToDisplay:=tmp
ActiveCell.Offset(1, 0).Select
Next i
End With
Set ws = Nothing
End Sub