Excel 2010 on Windows 7-VBA Not Responding

[MikeDBMan]

I recently was upgraded from Windows XP to Windows 7 and run Excel 2010. I have a fairly involved macro that modifies tables quite a bit. Oftentimes the macro seems to take a long time and if I click on the VBA window, it will fade out severely and the title gets (Not responding) added. It always seems to EVENTUALLY "come back" but this is quite annoying and I can't figure out how to prevent it. I start the program with:

Application.DisplayAlerts = False
Application.ScreenUpdating = False
Application.EnableEvents = False
Application.Cursor = xlWait
With Application
    .Calculation = xlManual
    .MaxChange = 0.001
End With

But it still happens. Suggestions?

 

[Norie]

Mike

Could it be happening because you start the code like that?

 

[MikeDBMan]

I do not think so. I turn those things off to help it run faster and have done so for years with no ill-effects.