Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi masters
Is there a way to open Qlikview and have the "Fit Zoom to Window" automatically applied to all sheets?
I have tried inserting the following on triggers but it did not work
Sub Zoom
ActiveDocument.ActiveSheet.FitZoomToWindow
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
End Sub
Please advise
Regards
Felipe Oliveira
May be this? You should call Zoon into OnOpen Trigger
Sub Zoom
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.FItZoomToWindow
End Sub
Fit Zoom to Window Document Extension
Extension only works in webmode or maybe Access Point.
May be this? You should call Zoon into OnOpen Trigger
Sub Zoom
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.FItZoomToWindow
End Sub
Hi,
It should be done in two diferent macro and then run one by one in two diferent action:
Sub FitZoomToWindow
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.FitZoomToWindow
ScreenUpdating = True
end sub
Sub ZoomToAllSheets
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
ScreenUpdating = True
end sub
BR
Ludzik