New to the Forum. Please tell me if this is not the correct forum for this Pivot Table question and what might be the appropriate forum. Thanks.
First, I found a Macro code from contextures.com that seems to Disable all drop down selectors for a pivot table. This is NOT what I'm trying to do.
I am looking for a Macro that disables certain items for a pivot table.
Scenario. I have a workbook that has two identical Pivot Tables in seperate worksheets. Both are linked to the same source data, seperate file. I have different ROW ITEMS selected in each of the Pivot Tables. I want to protect certain ROW ITEMS (not all) from update. I have the following Layout structure in my Pivot Tables. Page Items, Row Items, and Data. There are no Column Items.
For example, I have two PAGE ITEMS. Both of which I would like users to be able to select and deselect. They are named Accounting Period and Proc Party. I want these two to be active "selectable."
Next, I have three ROW ITEMS. Two of which I want users NOT to be able to select or deselect. The names of these are Payor and Payor Name. The third is Product. Product ROW ITEM I do want the users to be able to select or deselect.
Any help would be greatly appreciated!!! Thanks in advance.
Jason
Bookmarks