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