Styjun

What is the parallel of Day of the Dead with Stranger things?

Received a dinner invitation through my employer's email, is it ok to attend?

Efficiently defining a SparseArray function

WTB Horizon 47c - small crack in the middle of the tire

Credit score and financing new car

What's the point of having a RAID 1 configuration over incremental backups to a secondary drive?

How do you move up one folder in Finder?

What attributes and how big would a sea creature(s) need to be able to tow a ship?

Graduate student with abysmal English writing skills, how to help

How to tell someone I'd like to become friends without letting them think I'm romantically interested in them?

How can a dictatorship government be beneficial to a dictator in a post-scarcity society?

The three greedy pirates

How can I effectively communicate to recruiters that a phone call is not possible?

Why did Old English lose both thorn and eth?

Addressing unnecessary daily meetings with manager?

What happens when adult Billy Batson says "Shazam"?

Is it possible to split a vertex?

Why do we need common sense in AI?

Misrepresented my work history

Why different specifications for telescopes and binoculars?

Why archangel Michael didn't save Jesus when he was crucified?

Chorophyll and photosynthesis in plants with coloured leaves

Why would people still be chanting "Lock her up" at Trump rallies in 2019?

What is the correct parsing of お高くとまる?

To hide column based on slicer selection

How to avoid using Select in Excel VBAtrend analysis and conditional formatting with Excel Pivot TableExcel VBA - Check Report Slicer Selections (Skip if ALL are selected)Poor performance updating Excel slicer selection using VBAHide PivotChart columnsPowerPivot function/Target year Slicer issueProgrammatically select today's date on SlicerCalculate monthly average from daily data without PivotTableHow to remove a blank row from slicer?Selecting multiple slicer items based on a cell value

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have sales data. The last two columns are projection an agent ends at a month and the next is where he/she will end at the year. I have a slicer for Time period that has months and one option is YTD.
What I want is, if someone selects YTD, it hides the column "J", that has monthly numbers. I have very little knowledge about vba, i copied from here and there. but it doesn't work.

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
 If ActiveWorkbook.SlicerCaches("Slicer_end_of_mnth").SlicerItems("YTD").Selected = True Then
 Columns("J:J").Hidden = True
 Else
 Columns("J:J").Hidden = False
 End If
End Sub

excel vba pivot-table slicers

share|improve this question

edited Mar 26 at 0:32

BigBen

8,56933 gold badges88 silver badges2121 bronze badges

asked Mar 26 at 0:30

ShobiShobi

2288 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you explain what doesn't work? Do you get an error message?
  
  – BigBen
  Mar 26 at 0:48
  

  
  
  
  

add a comment | 

0

I have sales data. The last two columns are projection an agent ends at a month and the next is where he/she will end at the year. I have a slicer for Time period that has months and one option is YTD.
What I want is, if someone selects YTD, it hides the column "J", that has monthly numbers. I have very little knowledge about vba, i copied from here and there. but it doesn't work.

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
 If ActiveWorkbook.SlicerCaches("Slicer_end_of_mnth").SlicerItems("YTD").Selected = True Then
 Columns("J:J").Hidden = True
 Else
 Columns("J:J").Hidden = False
 End If
End Sub

excel vba pivot-table slicers

share|improve this question

edited Mar 26 at 0:32

BigBen

8,56933 gold badges88 silver badges2121 bronze badges

asked Mar 26 at 0:30

ShobiShobi

2288 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you explain what doesn't work? Do you get an error message?
  
  – BigBen
  Mar 26 at 0:48
  

  
  
  
  

add a comment | 

I have sales data. The last two columns are projection an agent ends at a month and the next is where he/she will end at the year. I have a slicer for Time period that has months and one option is YTD.
What I want is, if someone selects YTD, it hides the column "J", that has monthly numbers. I have very little knowledge about vba, i copied from here and there. but it doesn't work.

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
 If ActiveWorkbook.SlicerCaches("Slicer_end_of_mnth").SlicerItems("YTD").Selected = True Then
 Columns("J:J").Hidden = True
 Else
 Columns("J:J").Hidden = False
 End If
End Sub

excel vba pivot-table slicers

share|improve this question

edited Mar 26 at 0:32

BigBen

8,56933 gold badges88 silver badges2121 bronze badges

asked Mar 26 at 0:30

ShobiShobi

2288 bronze badges

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
 If ActiveWorkbook.SlicerCaches("Slicer_end_of_mnth").SlicerItems("YTD").Selected = True Then
 Columns("J:J").Hidden = True
 Else
 Columns("J:J").Hidden = False
 End If
End Sub

share|improve this question

edited Mar 26 at 0:32

BigBen

8,56933 gold badges88 silver badges2121 bronze badges

asked Mar 26 at 0:30

ShobiShobi

2288 bronze badges

share|improve this question

edited Mar 26 at 0:32

BigBen

8,56933 gold badges88 silver badges2121 bronze badges

asked Mar 26 at 0:30

ShobiShobi

2288 bronze badges

edited Mar 26 at 0:32

BigBen

8,56933 gold badges88 silver badges2121 bronze badges

edited Mar 26 at 0:32

BigBen

8,56933 gold badges88 silver badges2121 bronze badges

asked Mar 26 at 0:30

ShobiShobi

2288 bronze badges

asked Mar 26 at 0:30

ShobiShobi

2288 bronze badges