Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I set the scaling in my macro?
I am trying to edit my macro so that it selects fit to page 1x1. How can I
move the selector button in my macro to this field? I have added the following lines in my code and they work fine, but instead of moving the selector to "Fit To:" it stays at the default of "Adjust To:" wsNew.PageSetup.FitToPagesWide = 1 wsNew.PageSetup.FitToPagesTall = 1 Thank you! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I set the scaling in my macro?
Hi
Try this: With wsNew.PageSetup .Zoom = False .FitToPagesWide = 1 .FitToPagesTall = 1 End With Regards, Per "Gator" skrev i meddelelsen ... I am trying to edit my macro so that it selects fit to page 1x1. How can I move the selector button in my macro to this field? I have added the following lines in my code and they work fine, but instead of moving the selector to "Fit To:" it stays at the default of "Adjust To:" wsNew.PageSetup.FitToPagesWide = 1 wsNew.PageSetup.FitToPagesTall = 1 Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
axis scaling | Charts and Charting in Excel | |||
Forced Scaling | Charts and Charting in Excel | |||
Page Scaling | Excel Discussion (Misc queries) | |||
Scaling within a chart | Charts and Charting in Excel | |||
Dynamic Scaling | Charts and Charting in Excel |