ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Custom zoom (https://www.excelbanter.com/excel-programming/406265-custom-zoom.html)

Ed

Custom zoom
 
Hi,

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

Thanks.
--
Ed

Rick Rothstein \(MVP - VB\)[_1303_]

Custom zoom
 
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" wrote in message
...
Hi,

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

Thanks.
--
Ed



Ed

Custom zoom
 
Hi Rick,

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

Ed
--
Ed


"Rick Rothstein (MVP - VB)" wrote:

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" wrote in message
...
Hi,

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

Thanks.
--
Ed




Jon Peltier

Custom zoom
 
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Ed" wrote in message
...
Hi Rick,

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

Ed
--
Ed


"Rick Rothstein (MVP - VB)" wrote:

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" wrote in message
...
Hi,

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

Thanks.
--
Ed






Jialiang Ge [MSFT]

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.


Jialiang Ge [MSFT]

Custom zoom
 
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 , 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.



All times are GMT +1. The time now is 12:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com