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