Windows 7 - Printing preselected pages in Excel 2003

Asked By Johnnyboy5 on 09-Aug-12 02:56 PM
I want to be able to print some preselected pages - eg.  page 1,
3,4,5,  7  in a workbook of  10 pages.  I might need to change the
pages selected but am happy to edit the marco if anyone can write me
one.

Many thanks

John

Excel 2003.




Claus Busch replied to Johnnyboy5 on 09-Aug-12 03:24 PM
Hi John,

Am Thu, 9 Aug 2012 11:56:58 -0700 (PDT) schrieb Johnnyboy5:


preselet your pages and run the macro:
Sub myPrint()
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
End Sub

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Johnnyboy5 replied to Claus Busch on 10-Aug-12 04:27 AM
the

Sorry I dont fully understand your response.

how do I "preselect pages"   also not sure about the macro you wrote
there are a lot of ,,,,,,,,,,,, in it ,,,,,,,,,,,,,,

many thanks

John
Claus Busch replied to Johnnyboy5 on 10-Aug-12 05:11 AM
Hi John,

Am Fri, 10 Aug 2012 01:27:46 -0700 (PDT) schrieb Johnnyboy5:


in "Page Break Preview" you select your pages with pressed CTRL-Button,
then choose "Set Print Area" and run the macro

Sub myPrint()
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
End Sub

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Johnnyboy5 replied to Claus Busch on 10-Aug-12 02:04 PM
Got it now,   many thanks

John