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