Thread: VBA for spreadsheet background color - issues with pivottable

I tried VBA code that doesn't work because my pivottable sweeps away (it removes) the background color of my spreadsheet.

This is what I tried:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A1:CZ2000").Interior.Color = RGB(51, 102, 255)
End Sub

The above VBA does work to set the color....but as I use the pivottable, the background color is removed from the spreadsheet.

Thanks.

Is the pivot table output on the same sheet where you are putting the color?