This content has been marked as final.
Show 2 replies
-
Re: FitZoomToWindow Not working
Wojciech Parzyszek Feb 27, 2013 6:48 AM (in response to Helen Pippard)Hi Helen
try this macro:
SUB Zoom
set CurrentSheet=ActiveDocument.ActiveSheet
set proper=CurrentSheet.GetProperties
proper.ZoomFactor = 1 ' try 1 to 4
CurrentSheet.SetProperties proper
END SUB
-
Re: FitZoomToWindow Not working
Alexander Strohmaier Apr 7, 2015 9:20 AM (in response to Helen Pippard)Hey,
I had the same problem and found the answer there:
http://www.qlikblog.at/444/qliktip-16-zoom-mit-makro-automatisieren/
The tricky point is to add the following line between the commands:
ActiveDocument.ActiveSheet.FitZoomToWindow
ActiveDocument.GetApplication.WaitForIdle
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
ActiveDocument.GetApplication.WaitForIdle
I hope that helps!