Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
How do I change custom zoom to be larger than 400%? Thanks. -- Ed |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please help! Print Preview Zoom is Grayed Out...Doesn't zoom. | Excel Discussion (Misc queries) | |||
Zoom in/Zoom out picture | Excel Programming | |||
zoom in &zoom out in VBA User Form | Excel Programming | |||
Excel 2002, is there a custom zoom level? | New Users to Excel | |||
Is there a way to add custom views to the zoom button? | Excel Discussion (Misc queries) |