Excel XP: Page Setup Issue

How can I create different page setup options for each worksheet in a workbook? As I change the page setup within one worksheet it changes all of them. Is there a way to do this? Am I missing something obvious

Thanks in advance

Joe Mathis

"Joe Mathis" <jmathis@designworkshop.com> wrote in message
news:845FBE98-1D78-49BD-865A-6B3A397A41B9@microsoft.com...
> How can I create different page setup options for each worksheet in a
workbook? As I change the page setup within one worksheet it changes all of
them. Is there a way to do this? Am I missing something obvious?
>
> Thanks in advance,
>
> Joe Mathis

it shouldn't do.....it should save separate print options for each sheet.
How are you setting the page options?