Thread: Custom zoom
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jialiang Ge [MSFT] Jialiang Ge [MSFT] is offline
external usenet poster
 
Posts: 118
Default Custom zoom

Hello Ed,

We can programmatically change the view zoom value with the VBA code:
ActiveWindow.ActivePane.View.Zoom.Percentage = 200

Based on my test, if I set the Zoom percentage value to 600, it will throw
an error:
"one of the values passed to this method or property is out of range"

Therefore, as Rick said, this is a "built-in limit for the zoom function".
Would you consider Jon's suggesion and let us know if that works for you?

Thanks
Jialiang Ge , remove 'online.')
Microsoft Online Community Support

=================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.