"Opening file" Bar in Office 2010 Excel is blocking VBA execution

[Hans810]

Dear all,

I have a large VBA programme which was working very wel in the MSOffice 2003 version.
Now we have installed MSOffice 2010, the VBA is halting after some time.
We found out that in the Excel sheet, which is being approached by the VBA, a bar is shown in the upper part of the sheet, saying: "Do you want to open this file?"
Can someone tell my how to avoid this bar popping up. I assume that I can put some VBA lines in the ThisWorkbook section in the VBA.
That means that the VBA is blocking this popping-up bar right at the loading of the Excel file.
Any suggestions
Thanks in advance and kind greetings from Holland

 

[Jerry Sullivan]

Hello Hans from Holland,

There are some techniques that can suppress warning or information messages; however it would be better to understand the cause for that message before trying to make it go away.

If you'll provide some more information, we may be able to help you diagnose that.

1. Is this happening when your VBA code is trying to open an existing workbook?
2. Does it happen when you manually do the same steps that the VBA is doing?
3. Could you describe this "bar" more clearly? Is this a user dialog window? What is the entire text displayed?
4. Does the workbook being opened have external links?

 

[RoryA]

If you are talking about Protected View, is your code opening the workbook in question?

 

[Jerry Sullivan]

If you are talking about Protected View, is your code opening the workbook in question?

Ahh....that would make sense as something one would call a bar instead of a window.

I haven't seen that warning since Day 2 of using Excel 2010 when I turned it off!