The macro will print whatever sheet your code asks for.

How do your formulas return the data for "Print South Data" and where is that
data located?

If on another sheet, that is the sheet you want to print so select it.

If you posted your code we might get a better idea of how to direct it to the
proper location.


Gord Dibben MS Excel MVP

On Tue, 12 Jun 2007 10:34:01 -0700, tojo107
wrote:

I have a drop box menu that allows users to selecta region - North, South,
West, East and grand Total. When they select from the drop box, the formula
in the spreadsheet totals orders/sales for that region only (by looing at
other sheeets in the workbook.

I have created 5 separate form buttons that say "Print South Data"
and"PrintGrand Total".

So , when a user clicks the "South Data" button, it prints just the south
data from th edropdown. The issue I am having is that the Macro prints the
Active sheet in the drop box, not the one I want.

Any ideas?

Thanks,
Tom