Scree Resolution Problem

krishnacbe — Tue, 31 Jul 2012 13:04:23 GMT

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

Re: Scree Resolution Problem

fosuzuki — Tue, 31 Jul 2012 16:53:56 GMT

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