1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
| Private Sub CommandButton15_Click()
' je déprotèje toutes les feuilles
Dim LaFeuille As Worksheet
For Each LaFeuille In ActiveWorkbook.Worksheets
LaFeuille.Unprotect
Next
' je les rend tts visible
Dim MaFeuille As Worksheet
For Each MaFeuille In ActiveWorkbook.Worksheets
MaFeuille.Visible = xlSheetVisible
Next
' je rafraichi le TCD
Sheets("GL_Ana").Select
ActiveSheet.PivotTables("Tableau croisé dynamique1").PivotCache.Refresh
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowUsingPivotTables:=True
' je protège la feuille
ActiveSheet.Protect ' protection de la feuille
Range("a1").Select
'je rends la feuille GL_Ana visible
Dim a As Worksheet
For Each a In ActiveWorkbook.Worksheets
a.Visible = (a.Name = "GL_Ana")
Next a
Unload UserForm8
End Sub |
Partager