Application Visible with more than 1 workbook

[o0omax]

Thanks, i now have a better understanding of how to use those things!

I'm working on a different Macro where I am open and close many Workbooks. In the beginning of the Procedure I set Application.Visible = False. Still, when I use

Set wb = Workbooks.Open(filename)

the opened window still pops up and shows itself, even though i don*t do anything to the application. Do you know why it is?

I turned this on in the beginning and turned it off at the end (Still no performance increasement):

Public Sub SpeedUp(SpeedUpOn As Boolean)
     With Application
          If SpeedUpOn Then
               .ScreenUpdating = False
               .Calculation = xlCalculationManual
               .EnableEvents = False
               .DisplayStatusBar = False 'in case you are not showing any messages
         Else
              .ScreenUpdating = True
              .Calculation = xlCalculationAutomatic
              .EnableEvents = True
              .DisplayStatusBar = True
         End If
      End With
End Sub