Change Slicer Caption on sheet

[Siyanna]

Hi All,

How can I amend this code to change the slicer caption of a particular slicer on the active sheet


Im running this on the pivot table event on the sheet

If Worksheets("PivotSurvey").Range("AA2").Value = "State" Then
    ActiveWorkbook.activesheet.SlicerCaches("Lead Trainer Name").Caption = "Manager Name"
Else
    ActiveWorkbook.Activesheet.SlicerCaches("Lead Trainer Name").Caption = "Lead Trainer Name"
End If

 

[Domenic]

First, SlicerCaches is the property of the Workbook object. Secondly, Caption is the property of the Slicer object. Therefore, try...

ActiveWorkbook.SlicerCaches("Lead Trainer Name").Slicers(1).Caption = "Manager Name" 'refer to slicer by index

or

ActiveWorkbook.SlicerCaches("Lead Trainer Name").Slicers("Name"").Caption = "Manager Name" 'refer to slicer by name

Hope this helps!

 

[Siyanna]

Thank you

would that only work for the slicer on the active sheet buddy or a specific sheet?