Hi all, I have a macro that will locate files in a folder, then it will copy the worksheets and paste into the current workbook.

However It need to open up to 100 workbooks and copy and paste into the new workbook. During the run of the macro, I can see files opening and closing on the toolbar. is that possible to make those opening and closing of files not seen by the user?

Pls Advise.

Sub RunCodeOnAllXLSFiles()
   Application.ScreenUpdating = False
   Application.DisplayAlerts = False
   Application.EnableEvents = False


    'Macro code to copy from multiple workbooks to current workbook

    Application.ScreenUpdating = True
    Application.DisplayAlerts = True
    Application.EnableEvents = True

End Sub