selecting charts for printing
Print each chart individually
or
copy the charts to a blank worksheet and arrange them so the worksheet
isn't visible.
or
Hide what you don't want seen
in the same vein, put a large opaque shape behind the chartobjects
--
Regards,
Tom Ogilvy
"Tim" wrote in message
...
Hi,
i have a userform from which i would like users to select specific charts
to
print. there are 24 (pivot) charts over two sheets (12 per sheet).
i can select specific charts using the following: -
ActiveSheet.Shapes.Range(Array("ChartCool01", "ChartCool02")).Select
but in print / preview it shows the background worksheet too (i want just
graphs); anyone have ideas on how to print just the graphs collated
together? am i going about it all wrong?!
any help greatly appreicated as always,
Tim
|