selecting charts for printing

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" <t_marsh@---take-this-out-to-reply---atcentre.co.uk> wrote in message
news:eNjicikqFHA.3060@TK2MSFTNGP09.phx.gbl...
> 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
>
>