How do I ensure my Excel VBA application doesn't display each sheet as it processes them ?
Posted on 2014-11-12
My Excel application reads rows from one workbook and copies them to another. In fact, it processes each sheet in turn and depending on certain conditions selectively copies/pastes the rows to corresponding sheets.
The procedure opens an input workbook and an output workbook and amongst all this activity, the application switches from one sheet to another, opening a file and displaying the sheet that is currently active.
How do I stop this ? I want the procedure to run from the Menu sheet (click of a button) and all processing to be done in the background with the Menu sheet continually displayed until the end of the procedure.
I tried inserting Activate statements throughout the procedure but it got into a mess.
Is there a standard command which I can employ for this functionality.