Hello colleagues,

I'm working on 10 excel files for a client, and having trouble figuring out
how to print them the way I want to. Any help would be greatly appreciated.

Each file contains one large data worksheet, which prints out 17 pages, plus
several charts, each on its own sheet, created from various parts of the
data worksheet. There are from 5 to 20 separate chart sheets in each file. I
want to print JUST the chart sheets in each file, and NOT the 17 pages of
data.

The only way I can figure doing this is to open ALL the charts, one at a
time, and choose "Active Sheet" to print it out. But this will be
time-consuming and very annoying. Does anyone know of a way to print just
the chart sheets, skipping the data worksheet?

Thanks very very much!!

Melinda