topic macro stopping edit module window pops up in QlikView

macro stopping edit module window pops up

Tue, 24 Nov 2009 21:29:34 GMT

I am setting zoom of all the tabs on press of button. Essentially I am calling following line on press of a button in a loop to set zoom for each of the tabs:

ActiveDocument.Sheets(x).FitZoomToWindow .

Now while I press the button, the 'Edit Module' window pops up and I have to press Check and OK for each of the tabs to make the zoom happen correctly.

Can someone please tell me how to stop this popping up of edit module window.

Rgds

Tarun

macro stopping edit module window pops up

Fri, 27 Nov 2009 22:27:45 GMT

if the edit module window comes up on macro trigger, it means there is something wrong with your macro, kindly check it in the debug mode

regards

peter

macro stopping edit module window pops up

prieper — Fri, 27 Nov 2009 22:37:15 GMT

I think that FitZoomToWindow works only with the ActiveSheet-object, so you need to step through all sheets

ActiveDocument.ActiveSheet.FitZoomToWindow

Peter