Search : in
By :

Page Break Printing Issue

Last answer on Jan 25, 2009 10:15:58 am GMT Darshan, on Jan 24, 2009 5:58:41 pm GMT 
 Report this message to moderators

Hello,
I have a worksheet with sub-totals and page breaks auto inserted at the end of each sub-total. I want to print this report double sided, but with a condition. If an area between two page breaks fits onto a single of the paper, then I do not want to print the next break on the same sheet of paper.

If however, the area between two page breaks exceed one side of a paper and gets printed on the other, then I don't have an issue.

In short, I am trying to eject the paper from the printer if the data within a given break is printable on one side, and avoid the next chunk of data to get printed on the other side of the same sheet. Is this possible? Are there any addins/macros/VB codes that could deal with such printing requirements?? Please help.

Configuration: Windows XP
MS Excel 2003
Firefox 3.0.5

Best answers for « Page Break Printing Issue » in :
Reducing a Jpg image size ShowReducing a Jpg image size Step 1 (optional!): Skip GREYCstoration on the image Step 2: Reduce the resolution Step 3: Lower quality Step 4: Remove unnecessary information Conclusion If you find that your JPEG files are too large...
Background image/ Printed Watermark with Microsoft Word ShowBackground image/ Printed Watermark with Microsoft Word Insert a background image: Insert a Printed Watermark background: You might want to customize the blank background of your Word document either to advertise your business or...
Print Screen (Windows, Mac OS X and Unix/Linux) ShowHow to make a Print Screen (Windows, Mac OS X and Unix/Linux) What is a Print Screen? How to make a Print Screen (Windows) How to make a Print Screen (Mac OS X) How to make a Print Screen (Unix/Linux) Screen Capture Softwares What is a...
Download Right PDF Printer Pro ShowDescription Designed by rightfiles.com, the application has just been released. So far it is known and is being used worldwide in many companies. Easy and simple to use, Right PDF Printer acts like a virtual printer installed on your computer. The...
The Printer ShowPrinters The printer is a peripheral that allows you to make a print-out (on paper) of computer data. There are several printer technologies, the most common of which are: the daisy wheel printer the dot-matrix printer (also called impact...
HTML Markup ShowHTML, A Markup Language HTML is not a programming language. Rather, it is used for describing the layout and format of content, written in the form of simple text. An HTML page is a basic text file containing tags for specifying text format,...
Quoted-printable encoding ShowQuoted-printable encoding Quoted-printable encoding (somtimes QP) involves using US-ASCII 7-bits encoding (non-accented letters) to encode a text that requires an alphabet of 8-bit characters (accented letters), such as ISO-Latin-1, which is used...

1

 Elizabeth14, on Jan 25, 2009 10:15:58 am GMT

Hi,
try this link to see if it can help you:
http://www.ozgrid.com/VBA/

Reply to Elizabeth14