PivotSelect method issue

I've been working on this for HOURS now , so any help would be EXTREMELY appreciated ! I'm just trying to highlight the rows in my Client Detail Account PivotField based on another PivotField.

I have 2 Pivot Fields in this order:
1. Client Detail Account
2. Detail Service Code

So, If the Detail Service Code PivotField contains the ZBA MASTER ACCOUNT MAINT PivotItem, the code should highlight the Client Detail Account PivotField (ONLY THE Client Detail Account ROWS THAT MEET THE CRITERIA).

Currently, there are no errors in the code, but it highlights every single row of the Client Detail Account PivotField. Here is the potential culprit:

Please Login or Register  to view this content.

Here is the full code:

Please Login or Register  to view this content.

Any insight into how to make this happen would be MUCH APPRECIATED!

I have attached a sample as requested! You'll notice that all 3 account rows become highlighted when the button is clicked. I only want the Client Detail Account rows to highlight when the other pivot field contains "ZBA MASTER ACCOUNT MAINT ". Only accounts 1 and 2 in the example contain the ZBA pivot item I'm looking for. Account 1 and 2 are the only pivot fields that should highlight when the button is clicked.

Sample.xlsm

Hey Romper, thanks for the response. However, I am getting an error 'Application-defined or object-defined error' on the following code line:

Please Login or Register  to view this content.

Any luck trying this in 2007?