Excel XP: Page Setup Issue

[Guest]

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

 

[rifleman]

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?