|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 9th 12, 07:56 PM
posted to microsoft.public.excel.programming
|
|||
|
|||
Printing preselected pages in Excel 2003
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. 
|
| Ads |
|
#2
August 9th 12, 08:24 PM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing preselected pages in Excel 2003
Hi John,
Am Thu, 9 Aug 2012 11:56:58 -0700 (PDT) schrieb Johnnyboy5: > 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. 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
|
|
#3
August 10th 12, 09:27 AM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing preselected pages in Excel 2003
On Aug 9, 8:24*pm, Claus Busch > wrote:
> Hi John, > > Am Thu, 9 Aug 2012 11:56:58 -0700 (PDT) schrieb Johnnyboy5: > > > 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. > > 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 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
|
|
#4
August 10th 12, 10:11 AM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing preselected pages in Excel 2003
Hi John,
Am Fri, 10 Aug 2012 01:27:46 -0700 (PDT) schrieb Johnnyboy5: > how do I "preselect pages" also not sure about the macro you wrote > there are a lot of ,,,,,,,,,,,, in it ,,,,,,,,,,,,,, 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
|
|
#5
August 10th 12, 07:04 PM
posted to microsoft.public.excel.programming
|
|||
|
|||
|
Printing preselected pages in Excel 2003
On Aug 10, 10:11*am, Claus Busch > wrote:
> Hi John, > > Am Fri, 10 Aug 2012 01:27:46 -0700 (PDT) schrieb Johnnyboy5: > > > how do I "preselect pages" * also not sure about the macro you wrote > > there are a lot of ,,,,,,,,,,,, in it ,,,,,,,,,,,,,, > > 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 Got it now, many thanks John
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Printing to Day-Timer pages from Excel 2003 | Freelance | Excel Discussion (Misc queries) | 1 | March 5th 10 10:26 PM |
| Excel 2003 printing problem--printing 1 document on 2 pages | Bons | Excel Discussion (Misc queries) | 0 | December 24th 09 04:15 PM |
| How do I delete pages in Excel? Keeps printing blank pages at end. | Jojobean | Charts and Charting in Excel | 1 | May 31st 07 07:37 AM |
| Excel should allow printing of odd or even pages | Liz Geho | Setting up and Configuration of Excel | 1 | April 6th 06 10:52 PM |
| excel 2003 is missing data when printing pages | Dittovski | Excel Discussion (Misc queries) | 1 | October 7th 05 06:21 PM |
Linear Mode
