I have the following code:
What I want to do is determine what this will cause zoom factor to be and, if it is lower than 60%, assign ActiveSheet.PageSetup.Zoom = 60.
Please Login or Register to view this content.
Unfortunately I can't figure out how to pull the zoom value without assigning it manually. Any help?
Last edited by Phixer; 10-06-2014 at 03:12 PM.
Ok, Solved it, but it relies on ExecuteExcel4Macro, which might one day go away. I was hoping there was a more modern solution.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks