Bonjour,
le cpt tu l'as mis sur nouvelle_feuille (sheets(cpt?)
Dim La_feuille As String, Cpt As Integer
tester cela fonctionne comme cela
Option Explicit
Sub Menu()
Application.ScreenUpdating = False
Dim La_feuille As String, Cpt As Integer
La_feuille = ActiveSheet.Name
If LeMenu = True Then ' si LeMenu = vrai on affiche tout
With Application
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
Application.DisplayFormulaBar = True
Application.DisplayStatusBar = True
End With
With ActiveWindow
.DisplayHorizontalScrollBar = True
.DisplayVerticalScrollBar = True
.DisplayWorkbookTabs = True
End With
LeMenu = False
Sheets(1).Unprotect
For Cpt = 1 To 4
Sheets(La_feuille).Activate
Sheets(La_feuille).Shapes("Plein_écran").TextFrame2.TextRange.Characters.Text = "Plein écran"
ActiveWindow.DisplayHeadings = True
Next Cpt
Sheets(1).Protect
Else 'sinon on cache
With Application
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",false)"
Application.DisplayFormulaBar = False
End With
LeMenu = True
Sheets(La_feuille).Unprotect
For Cpt = 1 To 4
Sheets(La_feuille).Activate
Sheets(La_feuille).Shapes("Plein_écran").TextFrame2.TextRange.Characters.Text = "Petit écran"
ActiveWindow.DisplayHeadings = False
Next Cpt
Sheets(1).Protect
End If
Sheets(La_feuille).Activate
Application.ScreenUpdating = True
End Sub
crdlt,
André