Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page Setup, Scaling
In The Excel page, if you go to File Page Setup, in the Page tab, there's a
heading for Scaling. That has: Adjust to: % normal size, and Fit to: pages(s) wide by tall. Is there a way for me to mimic the Adjust to: % normal size property in VBA. I need to set that to 95% so that all the data on my page appears one page wide. I've already set the page orientation to Landscape, and edited the Right/Left Margins. I tried using the activeSheet.PageSetup.FitToPagesWide = 1 line, but it doesn't seem to cut the page to one page wide. Any help would be greatly appreciated, this is the last step for me on this macro. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page Setup, Scaling
Did you try recording a macro, that usually give you code to
use at the very least as a starting point. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "RSteph" wrote in message ... In The Excel page, if you go to File Page Setup, in the Page tab, there's a heading for Scaling. That has: Adjust to: % normal size, and Fit to: pages(s) wide by tall. Is there a way for me to mimic the Adjust to: % normal size property in VBA. I need to set that to 95% so that all the data on my page appears one page wide. I've already set the page orientation to Landscape, and edited the Right/Left Margins. I tried using the activeSheet.PageSetup.FitToPagesWide = 1 line, but it doesn't seem to cut the page to one page wide. Any help would be greatly appreciated, this is the last step for me on this macro. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page Setup, Scaling
I've got a macro set up already It does a host of things including
reformatting cell data, remove unneeded cells, resizing things, etc. I just need to figure out how to scale it down a little more to fit everything on one page. "David McRitchie" wrote: Did you try recording a macro, that usually give you code to use at the very least as a starting point. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "RSteph" wrote in message ... In The Excel page, if you go to File Page Setup, in the Page tab, there's a heading for Scaling. That has: Adjust to: % normal size, and Fit to: pages(s) wide by tall. Is there a way for me to mimic the Adjust to: % normal size property in VBA. I need to set that to 95% so that all the data on my page appears one page wide. I've already set the page orientation to Landscape, and edited the Right/Left Margins. I tried using the activeSheet.PageSetup.FitToPagesWide = 1 line, but it doesn't seem to cut the page to one page wide. Any help would be greatly appreciated, this is the last step for me on this macro. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel saving as web page and scaling the print out to fit one page | Excel Discussion (Misc queries) | |||
Page Scaling | Excel Discussion (Misc queries) | |||
Page breaks and scaling | Excel Discussion (Misc queries) | |||
Problem Scaling to 1 Page Wide | Excel Discussion (Misc queries) | |||
Page scaling & Page break preview prob | Excel Discussion (Misc queries) |