Printing both landscape and portrait in same print option

  • Thread starter Thread starter Snoopy
  • Start date Start date
S

Snoopy

Hey guys
I just wonder:
Are there any options to choose different print-settings for different
pages in one and the same print job from an Excel worksheet when using
multiple printingareas?

Ex: Side 1 (range A1:H35) is printed as portrait, while side 2 (range
C45:AA60) is printed as landscape.

I'll be very grateful for help

Regards Snoopy
 
Try Tools > Macro > Record new macro......then go through the entire
procedure, once more, by hand, then Tools > Macro > Stop
Recording........this should give you a macro to do the printing you desire.

Vaya con Dios,
Chuck, CABGx3
 
Thanks Chuck
I hoped not to use macros, but I understand its the only way....
My print-areas is not the same in every sheet..

Are there someone devine out in Excel-space capable to tell this humble
excelnaut how to make this interactive macro that makes the
Buck-sugested printing-macro useful in every occation?

I'm still grateful for help
 
Hi Snoopy,

Might be worth looking into exporting to other programs that are more
suited to this sort of thing. Autocad and Word are two that come to
mind but I,m sure there are many others that might suit your
individual needs. I'm not talking about importing just for printing
purposes, more along the line of creating the sheet in excel, exporting
it to another program and then do all the editing and printing from there.

Just a random thought
Martin
 
We have not experimented with "printingareas".

If it is the same as print area setting, then perhaps we can code it such
that it prints page by page (from:=2 to:=2) with the orientation set.
Users would know if it should be landscape or portrait while preparing the
spreadsheet.
So they can mark certain cells for the macro to pick up accordingly.
 
I'm very gratefull by your kindly respons
You''ve certainly gave me an angel to creative and exalted thinking.
Of course MS word could do the job - by some click-clack-humpel-pumpel
userbased/macro actions - a good idea...

The most temptational scope is to make a MS-Excel VBA macro as PY &
Associates sugested, but unfortunately that's beyond my competence.

And my conlusion goes like this:
I still have to suck my thumb, and try to enjoy the heavenly feeling of
using integrated MS Office solutions.
Unless...
.... one extremely helpful and unselfish VBA-freak find the devine
callinging in making such macro, and give me his (her) gently whisper
of wisdom.

Regards Snoopy
(Still hunting the Red Baron...Aaaaahhhhh)
 
Back
Top