T
tojo107
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
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