Screenupdating false macro

Although Excel will set this back to True whenever focus is passed back to Excel (in other words, when your macro finishes), in most cases it pays to play it safe and include the code at the end.

I have a file ("MENU TOTAL.xlsm") that has a macro to open other Excel files, retrieve data from them storing it in a variable, and then close the workbooks without saving.

The thing is, the opened Excel files have macros that run automatically and have, within the code, the Application. Everytime I run the macro in "MENU TOTAL.xlsm", I'd like NOT TO see the other workbooks opening and closing.

I guess this happens because the opened file has a macro (that also triggers the Screenupdating off and on...) that runs automatically when it is opened. Is there an alternative command to Screenupdating, or a way to stop auto-run macros from running? I hope someone can shed some light on this subject... Open Filename:=nomesficheiros(num_ficheiros_do_pais) Active Workbook.



It will automatically turn onwhen the macro is finished.If you need to update page numbers, you will have to show the application window before doing the update: With See Page X of Y displays or prints as Page 1 of 1, Page 2 of 2 etc. I hear rumors that you may also need to work with the Range object instead of the Selection object, but I have not tested this nearly enough to give a list because I do almost all of my work with Ranges.By turning off the screen updating your macros will run much faster.If you have played around a bit with macros or dabbled in VBA code, you might have heard of the to False at the start of a macro, you will not only stop the constant screen flicker associated with a recorded macro, but also speed up the macro's execution.


The reason this method speeds up code is because Excel no longer needs to repaint the screen whenever it encounters commands such as back to True on completion.

Word does not need to display itself in order to run.


  1. Pingback:

  2. eric   •  

    Some of the lava flowed over the north rim, cascading into Grand Canyon, forming spectacular "frozen" lava falls.

  3. eric   •  

    The terms "Russian mail order brides" and "Russian mail order wives", widely used by Americans, can be quite misleading as it almost creates the impression that the ladies would agree to marry just about anybody, which is miles far from the truth.

  4. eric   •  

    POP-BY IDEAS POP-BY TAGS I just wanted to let you know that Buffini and Company has a great resource for print ready pop-by tags. Our oldest daughter Lily is a 4th generation Girl Scout. My february pop-by is too cute and easy not to share.

  5. eric   •  

    Whether you are looking for a blonde, a brunette, a red head or a hottie of any type, Bo M is the place for you.

  6. eric   •  

    And they can expect real Mexican tamales for a long time, because I’m teaching my kids the tricks of the trade so one day they can inherit the business and experience the joy that comes with working hard and making great food for a great city.

  7. eric   •  

    Or at another time, did your mind ever go blank when your partner asked you to say something sexy in a text? [Read: Easy ways to start text flirting with a friend] Using sexy text messages to seduce your lover Firstly, if you want to seduce a sexy friend or a new lover, or want to start talking dirty for the first time through text messages, you need to read these features.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>