Printing on a different paper size per worksheet in Excel 1

[whatcom]

I have two worksheets in my Excel file - and I am printing to a PDF (so - no actual printer is involved).

I would like one worksheet to have the paper size set to print in "legal" format, and I would like the other to be set to print in "letter" format.

It seems that I have to choose either "legal" or "letter" for the entire document.

Is there a way around this?

 

[SkipVought]

Hi,

Turn on your macro recorder and record setting the paper size and printing for each.

Then use you macro for printing.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[whatcom]

I'm sorry all. It appears I made the "new" person mistake by not trying it first. It looks like you can do it.

I tried to delete the post as soon as I posted, but was unable do.

 

[SkipVought]

Been bit by that bug before, to boot. ;-)

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}