Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Would like to zoom qv objects using macro or button. can any one help?
use these marcos, it will zoom out and zoom in your sheet by 15% each time you click the button.
Sub ZoomOut
set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.ZoomFactor = sp.ZoomFactor+0.15
mysheet.SetProperties sp
End Sub
Sub ZoomIn
set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.ZoomFactor = sp.ZoomFactor-0.15
mysheet.SetProperties sp
End Sub
Regards,
Amay
use these marcos, it will zoom out and zoom in your sheet by 15% each time you click the button.
Sub ZoomOut
set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.ZoomFactor = sp.ZoomFactor+0.15
mysheet.SetProperties sp
End Sub
Sub ZoomIn
set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.ZoomFactor = sp.ZoomFactor-0.15
mysheet.SetProperties sp
End Sub
Regards,
Amay
Hi Sive,
Could you tell more about your case. Is it in Desktop or in Ajax...
Why do you need it etc.
Regards,
Sergey
The zoom macro will work in the desktop client and the IE plugin. It will not work in Ajax under Chrome or Safari.