Macro not working in QV9

[#1]

I have a simple macro which was working fine with QV 8.5, however since I upgraded to version 9 the macro opens the edit module screen when it first tries to run as if there is something wrong with the macro, however it works fine when I OK out of the edit module screen.

The macros is simply:

sub ZoomToFitWindow

ActiveDocument.ActiveSheet.FitZoomToWindow

end sub

Does anyone have any suggestions?

Thanks

[#2 · Accepted solution]

fixed by adding

ActiveDocument.GetApplication.WaitForIdle

to the macro

[#3]

Hey mcolombini

I have a similar issue except with mine, when i select run macro and i type in FitZoomToWindow, it doesn't work. it is supposed to run as soon as the sheet opens but it does nothing.

Any ideas on how to solve this?