Hi,
For a non vba solution how about covering the legend with an autoshape.
Format this to has the same colour as the chart area without a border.
Set the properties of the autoshape to not print, so legend is covered
in worksheet but revealed when printed.
Cheers
Andy
Alison wrote:
Is it possible to set up the Legend so that it only shows when it is in
prited format?
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info