Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppressing Worksheet Name When Zooming Out | Excel Worksheet Functions | |||
Hi all!! Suppressing the "Do you want to save changes" | Excel Worksheet Functions | |||
Suppressing output | Excel Programming | |||
Getting output from an excel output back to cscript.. | Excel Programming | |||
Suppressing messages | Excel Programming |