Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 09-04-2009
Member
 
Join Date: Dec 2008
Posts: 52
Block the zoom value by VBA

hello,
I want advise to ensure that the code to open a excel file is corect, the value of the zoom or freeze and can not be altered by the user. for example : the block to 52%.

thank you in advance to all.
Reply With Quote
  #2  
Old 09-04-2009
Member
 
Join Date: May 2008
Posts: 4,829
Re: Block the zoom value by VBA

there is no event that can detect the change of zoom. the only thing you can do is to prohibit the use of orders of the collection Zoom command display.
To do this we must detect the click on it commands. to detect the click must have access to the event click on the commands. The problem is that this event is not available Live excel. The only way to get it is to create a class commandebarbouton and use the Event Office.
Reply With Quote
  #3  
Old 09-04-2009
Member
 
Join Date: May 2008
Posts: 4,565
Re: Block the zoom value by VBA

A half-solution is to use the event SelectionChange which operates at each change of the cell, so very often ... with:
Code:
Private Sub Worksheet_SelectionChange (ByVal Target As Range) 
ActiveWindow.Zoom = 52 
End Sub
and also to see this action in opening the file ...
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Block the zoom value by VBA"
Thread Thread Starter Forum Replies Last Post
1/4 block auto-block and 1/6 block auto throw techniques destroying Street Fighter X Tekken Rashid Video Games 6 30-04-2012 12:30 PM
Unable to Zoom in and Zoom out on Farmville. Jaganmohini Video Games 3 29-01-2011 05:32 AM
need Zoom Q3 camcorder Triple-X Portable Devices 3 16-10-2009 08:24 AM
How to Use Zoom In Firefox 3 ? Conrad Tips & Tweaks 1 06-03-2009 05:59 PM
Canon Vb-c60 Pan/tilt/zoom Network Camera Featuring An Ultra-long 40x Optical Zoom And Powerful Digic Net Processor jasonR Portable Devices 0 12-09-2008 04:21 PM


All times are GMT +5.5. The time now is 06:15 PM.