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 |
All times are GMT +1. The time now is 09:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com