Bonjour,
L'alternative est de faire un module VBA (Macro):
Option Explicit
Public Sub EnableSelection()
Dim pt As PivotTable, pf As PivotField
Set pt = ActiveSheet.PivotTables(1)
Set pf = pt.PageFields("RAC")
pf.ClearAllFilters
pf.EnableItemSelection = True
Set pf = Nothing: Set pt = Nothing
End Sub
Public Sub DisableSelection()
Dim pt As PivotTable, pf As PivotField, sPI As String
sPI = "CPASCAL2"
Set pt = ActiveSheet.PivotTables(1)
Set pf = pt.PageFields("RAC")
On Error GoTo err_Handler
pf.CurrentPage = sPI
pf.EnableItemSelection = False
exit_Handler:
Set pf = Nothing: Set pt = Nothing
Exit Sub
err_Handler:
MsgBox "Le champ " & sPI & " est inconnu.", vbInformation
Resume exit_Handler
End Sub
Cela permet de bloquer le bouton pour changer de nom dans mon cas, comme cela il ne peut pas acceder aux donnees des autre utilisateurs.
Cordialement.