PC Review


Reply
Thread Tools Rate Thread

Already Zoomed Out as Far as Possible

 
 
ryguy7272
Guest
Posts: n/a
 
      11th May 2009
I am trying to come up with a way of preventing a user from zooming out too
far. Is there a way to limit the user to say 30% of zoom. I have this:

If ActiveWindow.Zoom <= 30 Then
ActiveWindow.Zoom = 40
MsgBox("Already Zoomed Out as Far as Possible", _
vbOKCancel, "Max. Zoom")
End If

Somehow, the event has to be fired by a mouse scroll event, I presume. This
would be for the ActiveSheet, not an object such as a ComboBox, or anything
else.

Thanks,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
zoomed joe.the.lad Windows Vista Performance 2 28th Mar 2008 06:07 AM
Zoomed in files =?Utf-8?B?TW91bnRfRHJlYW1lcg==?= Microsoft Excel Misc 3 30th Aug 2007 08:26 PM
Zoomed in Screen =?Utf-8?B?aGFsdm9ydmE=?= Windows XP Help 1 29th Jul 2006 10:31 PM
zoomed in screen nosila0212 Windows XP General 4 15th Nov 2005 05:58 AM
Video Is Zoomed HaTcH Windows XP Video 0 21st Jan 2004 01:04 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:15 AM.