Hi,

I have created an Excel workbook that shows performance of a sales
force by the use of a graph and a drop down list (so that I don't need
to create a new worksheet for every employee). The drop down list is
in cell B5 and the worksheet is called 'Sales'.

I have been asked to create a print macro that will print out the
graph for each employee but I don't know how to go about creating a
print macro that can cycle through the drop down list and print off
the 7 performance graphs (for the 7 employees in the list).

I have previously hacked together a print macro way back in Excel 2000
which cycled through different worksheets printing each one in turn
but I have no idea how to go about printing different graphs sourced
from a single worksheet. Can anyone help?

DS