Macro for autozoom in IE plugin not working on Access Point

[Anonymous]

Hi!

In order to get the correct screen resolution when using IE Plugin on the Access Point we have in "Document Setting/Properties,Trigger, OnOpen" saved this macro called Zoom.  Unfortunately this macro is not working on the access point.  Are there some parameter/settings in the qvw-document or on the server that we should check?  

We are using QV 11 and Internet Explorer 9. On the server we have selected "Allow macro execution on server" and "Allow unsafe macro execution on server", but this does not solve our problem.  Are there some other settings that can affect running the macro (in the qvw or the server)?

Sub Zoom
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.FitZoomToWindow
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
End Sub

[fosuzuki]

Try adding your server to the Local Intranet zone in IE Options > Security > Local Intranet > Sites > Advanced > Add this site to zone

By default, IE9 has some security settings that will not enable the ActiveX magic if you are in Internet zone.

[Anonymous · Accepted solution]

Hi Fernando!

Thanks for your reply!  The security settings in IE was already OK, but we have now solved our problem.

The macro did not work because we had quite many sheets with conditional show and the macro under Document/Settings just changed the screen resolution on the active sheet.  We have now defined the macro on all the sheets and the macro works fine now.