"file in use" Message Box not displaying when using VBA to open multiple file

[egoburnswell]

I'm currently using the loop:

For i = 1 To 10
Application.Workbooks.Open ( files(i) )
Next

To open several excel workbooks.
It works fine, but the standard message "File in Use" message box doesn't display, and the files just open in Read-Only mode without warning.
Is there any way to get this message box to display?

I could put an if statement and my own message box, but I'd rather avoid this.

Thanks

 

[daverunt]

See if the info here is any help.

vba - Skip automatically pop up of "Open as read-only?" - Stack Overflow