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

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