Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Value of Zoom print setting
Jim Rech and Nick Osdale-Popa posted this that might help:
http://groups.google.com/groups?thre...%40tkmsftngp05 MacroMan wrote: Please Help! I am using VBA in Excel XP with Windows 2000. When you manually set the "Fit To" print settings to one page wide by one page long the "Zoom" percent value changes even though the "Fit To" option is being used. Because the Zoom option is not on, its value is set to "False" if you try to retrieve that percentage using "Activesheet.PageSetup.Zoom". I need to obtain that percentage when the "Fit To" option is on. How can I get it? Your example code is most appreciated. Thanks in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help! Print Preview Zoom is Grayed Out...Doesn't zoom. | Excel Discussion (Misc queries) | |||
Setting Default Zoom | Excel Discussion (Misc queries) | |||
setting of screen zoom in excel | Excel Discussion (Misc queries) | |||
Setting zoom for all worksheet pages | Excel Programming | |||
Setting zoom for all worksheet pages | Excel Programming |