Scree Resolution Problem

[krishnacbe]

Hi

I have used below steps to Fit the Screen

Go to Tools -> Edit Module

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

Click "OK"

Setting -> Sheet Properties

Select the "Triggers" tab

Click the "Add Action(s)..." button under OnActiveSheet

Click Add

Select "External" from the left hand list and "Run Macro" from the right hand list. Click "OK"

Type "Zoom" under Macro Name

Click "OK" until you have exited all the windows.

This works fine in Qlikview Desktop. In IE Plugin some problem occurs, screen is not fit to the window. I am using IE 8 version.

Thanks In advance

[fosuzuki]

Hi,

try this code, I've found on the community some time ago...:

sub ZoomWithErrorCheck

          set doc = ActiveDocument

          set aSheet = doc.ActiveSheet

          aSheet.FitZoomToWindow

          doc.GetApplication.WaitForIdle 300

          aSheet.ApplyZoomToAllSheets     'if you want the same zoom to be applied to the other sheets

end sub

Hope this helps you

Fernando