Highlighting the selected PivotTable cell

S

Steve Newbery

In a PivotTable, we use VB code to select a certain cell, by setting
the Selection property. This works fine.

The problem is that the selected cell is not very visible to the user
- it just has a light violet coloured border and is hard to see.

I cannot find a way to either change the default selection color, nor
a way to programmatically highlight the selected cell, ie by setting
its background color or making it bold or something.

Any ideas anyone?
 
Top