You need to loop through the sheets and set up each sheet or sheets as you
want.

Basically creating two different print jobs.

One for sheet1 and one for sheet2 and 3


Gord Dibben MS Excel MVP

On Tue, 28 Jul 2009 11:24:01 -0700, user
wrote:

hello

how can I set up macro for different page setup.
For ex, i have 1 ws that have different left/right margin then the 2 ws.
I set up my macro, but when I run it, the page set-up is going back to the
original.