2 Replies Latest reply: Nov 27, 2009 5:37 PM by Peter Rieper RSS

    macro stopping edit module window pops up

    tarun kandwal

      Hi

      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