Custom zoom

[Ed]

Hi,

How do I change custom zoom to be larger than 400%?

Thanks.

 

[Rick Rothstein \(MVP - VB\)]

Given the warning box that appears when you try to manually enter a zoom
value larger than 400% says "The number must between 10 and 400", I am going
to guess that 400 is a built-in limit for the zoom function (meaning it
probably cannot be exceeded). By the way, I have looked at things blown up
to 400%... they are pretty big... do you **really** need a larger zoom
factor?

Rick

 

[Ed]

Hi Rick,

I trace locallive pictures at 400%. 500% or 600% might be better for what I
am doing.

Ed

 

[Jon Peltier]

Leaving aside the debate whether Excel is the proper tool...

Is the "locallive" picture an embedded object? Could you increase the size
of this object?

- Jon

 

[Jialiang Ge [MSFT]]

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 ([email protected], 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.

 

[Jialiang Ge [MSFT]]

Hi Ed,

If you need further assistance, feel free to let me know. I will be more
than happy to be of assistance.

Have a great day!

Regards,
Jialiang Ge ([email protected], 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.