| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to print a sheet by command
Hi,
I have a sheet with information. What I want to do is making two commands, one for print the sheet portrait, and the other one landscape Can any one help me plzzzzzzzzzzzz Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to print a sheet by command
How about recording a macro when you print landscape and record another when you
print portrait? ghost wrote: Hi, I have a sheet with information. What I want to do is making two commands, one for print the sheet portrait, and the other one landscape Can any one help me plzzzzzzzzzzzz Thanks! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to print a sheet by command
yes
can you give the code please "Dave Peterson" wrote: How about recording a macro when you print landscape and record another when you print portrait? ghost wrote: Hi, I have a sheet with information. What I want to do is making two commands, one for print the sheet portrait, and the other one landscape Can any one help me plzzzzzzzzzzzz Thanks! -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to print a sheet by command
On May 1, 4:36 pm, ghost wrote:
can you give the code please You need to come to the party. If you don't know how to record the macros, you should ask. More importantly, if you don't know how to record macros, then chances are you won't know what to do with the code when someone takes the time out to give it to you. <cynical unless you are going to cut and paste it into some kind of assignment </cynical Here's a taster of the solution, assuming you have activated the worksheet that you want to modify. ActiveSheet.PageSetup.Orientation = xlPortrait And from the Menu, Tools, Macro...Record New Macro....Hit OK. Do what you want to do (e.g change the page layout) Then hit the Stop button. Hit ALT F11, and you should see the code. You may need to click on Modules and/or Module1 on the left. HTH Andrew |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to print a sheet by command
ToolsMacroRecord New Macro.
Gord Dibben MS Excel MVP On Tue, 1 May 2007 08:36:00 -0700, ghost wrote: yes can you give the code please "Dave Peterson" wrote: How about recording a macro when you print landscape and record another when you print portrait? ghost wrote: Hi, I have a sheet with information. What I want to do is making two commands, one for print the sheet portrait, and the other one landscape Can any one help me plzzzzzzzzzzzz Thanks! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| command button print | Excel Discussion (Misc queries) | |||
| How to format the extension less file to print with Dos's Print Command | Excel Discussion (Misc queries) | |||
| Print Command | Excel Discussion (Misc queries) | |||
| Print command box | Excel Discussion (Misc queries) | |||
| How do I create a command button to jump from sheet to sheet in a. | Excel Worksheet Functions | |||
Linear Mode
