| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
printing
how do I set a macro to change the orientation to landscape and seperately to
portrait? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
printing
Record a macro when you make your changes. You'll see the code.
ynissel wrote: how do I set a macro to change the orientation to landscape and seperately to portrait? Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
printing
I tried but it added like 15 lines of code and takes the marco an extra 30-40
seconds to run and the screen keeps flashing. Is there a 1 liner I can add? "Dave Peterson" wrote: Record a macro when you make your changes. You'll see the code. ynissel wrote: how do I set a macro to change the orientation to landscape and seperately to portrait? Thanks -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
printing
You can edit your recorded code to just the lines that you need. Just keep the
line that changes orientation, for example. ynissel wrote: I tried but it added like 15 lines of code and takes the marco an extra 30-40 seconds to run and the screen keeps flashing. Is there a 1 liner I can add? "Dave Peterson" wrote: Record a macro when you make your changes. You'll see the code. ynissel wrote: how do I set a macro to change the orientation to landscape and seperately to portrait? Thanks -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
printing
thanks - Ill try it now.
"Dave Peterson" wrote: You can edit your recorded code to just the lines that you need. Just keep the line that changes orientation, for example. ynissel wrote: I tried but it added like 15 lines of code and takes the marco an extra 30-40 seconds to run and the screen keeps flashing. Is there a 1 liner I can add? "Dave Peterson" wrote: Record a macro when you make your changes. You'll see the code. ynissel wrote: how do I set a macro to change the orientation to landscape and seperately to portrait? Thanks -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Page Setup Printing | Excel Discussion (Misc queries) | |||
| Borders not Printing | Excel Discussion (Misc queries) | |||
| Printing worksheet not the same across the board | Setting up and Configuration of Excel | |||
| Printing Recto/Verso | Excel Discussion (Misc queries) | |||
| problem printing to PDF | Excel Discussion (Misc queries) | |||
Hybrid Mode
