Thanks Andy, it worked like a charm.

Tony

"Andy Pope" wrote:

Hi,

Use Tools Options View and change the setting of Objects to Show All
instead of Show Placeholders.

Cheers
Andy

Tony Parks wrote:
I have charts on the worksheet, but they are covered in gray unless I select
the chart.
They also print in gray unless selected.

How do I get this formatting turned off?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info