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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top