Is there a way, in Excel 2016, to disable the multi-select and select all options in a pivot table filter? I found the below post from a couple of years ago and I tried using the VBA syntax from this.
Private Sub Worksheet_Change(ByVal Target As Range)
ntPage = "(All)" Then
MsgBox "Select All-LOB instead", vbCritical + vbOKOnly, "Filter Selection" 'optional message
ageItems = False
However, in my worksheet, the message box is put in an infinite loop. Every time I click ok or try to exit out, it pops up again.
Can anyone help me correct this.