Sub Précédente()
Dim NomService As String
NomService = ActiveSheet.Range("A2")
Application.ScreenUpdating = False
If ActiveSheet.Index > 4 Then
ActiveSheet.Previous.Activate
ActiveSheet.Unprotect Password:="toto"
ActiveSheet.Range("A2") = NomService
ActiveSheet.Protect Password:="toto"
ActiveSheet.EnableSelection = xlUnlockedCells
End If
Application.ScreenUpdating = True
End Sub
*********************************************
Sub Suivante()
Dim NomService As String
NomService = ActiveSheet.Range("A2")
Application.ScreenUpdating = False
If ActiveSheet.Index <> Sheets.Count Then
ActiveSheet.Next.Activate
ActiveSheet.Unprotect Password:="toto"
ActiveSheet.Range("A2") = NomService
ActiveSheet.Protect Password:="toto"
ActiveSheet.EnableSelection = xlUnlockedCells
End if
Application.ScreenUpdating = True
End Sub