Hi All,
I am using a macro to zoom all sheets to fit the window.The macro is:
SUB FitZoomToWindow
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.FitZoomToWindow
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
END SUB
But the problem is when I open the document for the first time when qlikview is not opened at all then the qlikview window is small by default and the document gets maximised only until the small qlikview window.After I maximize qlikview window and click on any sheet then the zoom is ok because of macro trigger on activate sheet.Do we have a macro which maximizes the qlikview window to the screen size or is there any settings which I need to check?