I have two pivot tables in two worksheets. The first one is controlled by a combo box in which the user selects a business ID. The information for that ID then appears in that worksheet's pivot table.
The second pivot table has two combo boxes that are filled based on the user's selection in the first worksheet's combo box. The first of the two combo boxes lists the states in which the selected business ID operates. When a selection is made then the second combo box is filled with the counties in the selected state in which the business operates. The second pivot table is then filled when all similar businesses in the selected county, including the selected ID from the first worksheet.
I added some code so that the selected business would be highlighted in the second pivot. My problem is that the highlighting doesn't go away. I wrote some code that deletes the highlighting when the worksheet is deactivated but it seems to persist anyway.
Does anyone know how to do this so that the highlighting doesn't persist?
The second pivot table has two combo boxes that are filled based on the user's selection in the first worksheet's combo box. The first of the two combo boxes lists the states in which the selected business ID operates. When a selection is made then the second combo box is filled with the counties in the selected state in which the business operates. The second pivot table is then filled when all similar businesses in the selected county, including the selected ID from the first worksheet.
I added some code so that the selected business would be highlighted in the second pivot. My problem is that the highlighting doesn't go away. I wrote some code that deletes the highlighting when the worksheet is deactivated but it seems to persist anyway.
Does anyone know how to do this so that the highlighting doesn't persist?
