SETUP MARGINS QUESTION

[Martin ©¿©¬]

Hi
I have a 4 page worksheet
In Print preview/Setup/Margins how do I make the margins of page 4
different from the other 3?

 

[Dave Peterson]

I would record a macro when I changed the margins, printed the first 3 pages.

Then changed the margins and printed the 4th page.

Then I'd just rerun this macro whenever I needed to do this.

 

[Gord Dibben]

Separate print jobs.

You could do this via VBA but would still be two distinct print jobs.


Gord Dibben MS Excel MVP

 

[Martin ©¿©¬]

Separate print jobs.
You could do this via VBA but would still be two distinct print jobs.

Thanks Dave & Gord
I thought it would be a simple job of just adjusting margins,
as I have no experience of recording a macro or VBA
I'll just put the 4th page on a different worksheet
Now that I think about it, it's easier for me, as it will probably be
a one-off
Thanks for your replies, they have helped me look at my prob
differently