ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Suppressing output (https://www.excelbanter.com/excel-programming/309354-re-suppressing-output.html)

Norman Jones

Suppressing output
 
Hi Ben,

Try:

Application.ScreenUpdating = False

'Your code

Application.ScreenUpdating = True

---
Regards,
Norman



"Ben H" wrote in message
...
Hi all! I am calling different files in a macro. The macro opens the
files,
reads in some data and then closes them. The problem I have is that the
files that are opened pop up and i was wonderig if there was a way to
suppress that.
Its really annoying to have the tables flash up and then dissapper.
Thanks!





All times are GMT +1. The time now is 08:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com