Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract auto-calc % scale so as to construct a macro to addcontrolled Page Breaks
I am trying to allow Excel to scale a document so that it occupies the
full width of a landscape page. Of course the automatic scaling feature can do this. However, when that happens I want to be able to control the Page Breaks. This has long been a problem for me. I am wondering if there is a solution anyone knows. Or perhaps someone can tell me how to extract the % scale that Excel automatically calculated when set to the 'fit to page' option so that I can use that number and manually plug it into a print macro. I know that if I set the print to automatically adjust to fit the page, the reduction number is displayed to me. I just do not know how to extract that number so that I can use it, or if it is even possible. Thanks for anyone's help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract auto-calc % scale so as to construct a macro to addcontrolled Page Breaks
On Aug 10, 11:44*pm, RJQMAN wrote:
I am trying to allow Excel to scale a document so that it occupies the full width of a landscape page. *Of course the automatic scaling feature can do this. *However, when that happens I want to be able to control the Page Breaks. *This has long been a problem for me. *I am wondering if there is a solution anyone knows. *Or perhaps someone can tell me how to extract the % scale that Excel automatically calculated when set to the 'fit to page' option so that I can use that number and manually plug it into a print macro. *I know that if I set the print to automatically adjust to fit the page, the reduction number is displayed to me. *I just do not know how to extract that number so that I can use it, or if it is even possible. Thanks for anyone's help. I found the answer on a microsoft help site! Just setting the number of pages option to 'False' allows the automatic function to still work and maintain the page breaks. I do not mean to waste anyone's time, and hopefully this information will help someone else. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print auto page breaks | Excel Discussion (Misc queries) | |||
auto add page breaks | Excel Discussion (Misc queries) | |||
Page Breaks Macro | Excel Programming | |||
auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
Auto insert page breaks in Excel, based on a sort of numbers | Excel Discussion (Misc queries) |