PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field.
Passing PivotTable name in PivotName, then name of field to be filtered
Then Pass 1 in Show1_or_Hide2 to show these items, or pass 2 in it to hide them
Then finally, the actual item to be showen/hidden, or list of items separated by Sepa (default to |)
Will return 1 if applied with no errors, returns 0 if there was an error.

CodeFunctionName What is this?

Public

Tested

Original Work

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 Boldcodes.com

Linkedin Login

PivotName, PivotField, PivotItems, Show1_Or_Hide2, Optional Sepa = "|", Optional WB = "This", Optional Shee="Active"

Views 235

Downloads 106

CodeID
DB ID