#1   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 279
Default Custom zoom

Hi,

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

Thanks.
--
Ed
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.programming
Ed Ed is offline
external usenet poster
 
Posts: 279
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default 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





  #5   Report Post  
Posted to microsoft.public.excel.programming
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.



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 118
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please help! Print Preview Zoom is Grayed Out...Doesn't zoom. PK Excel Discussion (Misc queries) 0 July 20th 09 03:33 PM
Zoom in/Zoom out picture [email protected] Excel Programming 1 January 27th 08 04:19 PM
zoom in &zoom out in VBA User Form [email protected] Excel Programming 0 January 21st 08 04:59 AM
Excel 2002, is there a custom zoom level? jbclem New Users to Excel 2 December 11th 06 11:40 AM
Is there a way to add custom views to the zoom button? duugg Excel Discussion (Misc queries) 2 April 25th 06 06:09 PM


All times are GMT +1. The time now is 08:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"