Shows or hides an item or items in a PivotTable filter field.
Passing PivotTableName, Sheetname, workbook (assuming it is open), field name to be filtered, item (or list of items separated by |) that we want to show or hide and finally 1 or 2 to show or hide.
One piece of code had buried in my old tools.
Edit 2025-01-13: Adding fix for Activesheet in selected workbook
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Bold.codes
Linkedin Login
PivotName, PivotField, Show1_Or_Hide2, Optional WB = "This", Optional Shee="Active"
Views 209
Downloads 121
CodeID
DB ID
