AUTO PRINT potrait & landscape

colleen · Mar 28th, 2002, 06:52 AM

hi , i need to print my documents first page potrait the rest in landscape mode automatically without manually clicking on potrait and first page the landscape for the balance pages. All these douments are on the first sheet .. aid needed colleen

Anne Troy · Mar 28th, 2002, 07:13 AM

Record a macro while you do it, Colleen. Though I don't have the instructions for Excel just yet, I've got the instructions for recording a Macro in Word at:

http://www.thewordexpert.com/wordvba...ToRecordAMacro

The instructions are VERY similar, except the bit about putting a toolbar button on the toolbar. In Excel, you take that step AFTER you record the macro.

Mar 28th, 2002, 07:13 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Record a macro while you do it, Colleen. Though I don't have the instructions for Excel just yet, I've got the instructions for recording a Macro in Word at: http://www.thewordexpert.com/wordvba...ToRecordAMacro The instructions are VERY similar, except the bit about putting a toolbar button on the toolbar. In Excel, you take that step AFTER you record the macro. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 28th, 2002, 06:52 AM	#1
colleen Board Regular Join Date: Feb 2002 Posts: 61	hi , i need to print my documents first page potrait the rest in landscape mode automatically without manually clicking on potrait and first page the landscape for the balance pages. All these douments are on the first sheet .. aid needed colleen