Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Horiztonal page breaks and Margins feb08
Hi All,
I have some general questions at the end of this background info: I'm building an app in an addin that prints route "books" where each book is a worksheet. A manger control's his/her Excel workbook where there will be 10-15 route worksheets. A printed page is NOT 8.5x11 inches, but smaller. Paper size is the same for all mangers. A manager can set the rows per page for each route, RowsPPg is the variable. I currently use horizontal page breaks for the pages, (there is only 1 vertical break per Ws) but I found that the processing is very slow when pages, (the RowsPPg quantity of rows) are inserted / deleted and I have to reset the horizontal break when more than a few pages are in play. I have lots of working code page inserts and deletions, the row height which controls the rows that can print on 1 page, font size, etc. It occurred to me that if I fool with the upper and lower margins in the Excel page setup for each route Ws, the page breaks will be "set" by Excel and I woult not have to control the horizontal break. Q1. Generally, sounds like the right way to go ? Q2. I know that some trial and error will be involved, but, how close to the bottom of a piece of paper will I be able to print ? 2a. Is there a way to override the "fix margin" messages that I get sometimes ? 2b. Do I now have to worry about the kinds of printers the mangers will use to print the books ? The company has many kinds of printers. Thanks much, Neal Z. -- Neal Z |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't move my page breaks in Page Break Preview | Excel Discussion (Misc queries) | |||
When automatic page breaks are moved each cell becomes a new page | Excel Discussion (Misc queries) | |||
Vertical page breaks won't drag in Page Break Preview | Excel Discussion (Misc queries) | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
Page Breaks- Printing selected rows on same page | Excel Discussion (Misc queries) |