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.
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 Mydev.net
Linkedin Login
PivotName, PivotField, Show1_Or_Hide2, Optional WB = "This", Optional Shee="Active"
Views 207
Downloads 121
CodeID
DB ID
