How do I prevent my macro from hanging when Opening or Closing a workbook?

[USAMax]

I have a macro that opens workbooks collects information and closes the workbook.

It runs perfectly when I have a break point in the program, I just have to hit F5 to continue.

I am running a UserForm as vbModeless to show where I am in the process.

When I let it run it locks on a few workbooks when it Opening or Closing a workbook. Currently it is always the 11th workbook.

Is there a fix for this?

 

[Norie]

Have you tried sprinkling some DoEvents statements in the code?