vba if message box pop up then

[Pinaceous]

Hi All,

Is there a vba code that can be created to respond to a message box pop up?

I need help on starting this code, for example, if a message box pops up then

'do something.

Please let me know.

Thank you!
Pinaceous

 

[Joe4]

I have never heard of such a thing.
I am not aware of any event that waits and watches for that.

If you answer the last two questions from my last post, there is a possibility that we may be able to do something to affect the behavior a little bit (depending on what the answers to those questions are).

 

[Pinaceous]

That is odd. Typically those messages pop to the top without you having to do anything.
What is showing up on top of it?
Do you have any automated VBA code that is running when the workbook is opened?

What is showing up on top of it?

Microsoft Excel as you can see here.

Do you have any automated VBA code that is running when the workbook is opened?

I do have an automated VBA message box that appears, once the document is enabled that welcomes the user.


Hope these were the two questions you needed answered but if not please let me know.

Thank you,
pinaceous

 

[Joe4]

I thought the issue was the following:

I'm working with an Excel file, which is providing a message box upon its opening but it remains in the background behind the Excel document and does not come forward, which is causing a lot of confusion to say the least!

So I was trying to see if there is any VBA running at the same time which would take precedence over it, and maybe that is why it is getting pushed to the back.
If you disable all VBA code, does that message box still get pushed to the back?

What relation does the document named in that message box have with your current workbook?
Are they linked?
Do you have VBA code in the current workbook trying to open that other workbook?

 

[Pinaceous]

If you disable all VBA code, does that message box still get pushed to the back?

If I do not enable the document that message box does not appear at all.

What relation does the document named in that message box have with your current workbook?

The workbook name that we are working with appears in that message box.
For example, NewExcel.xlsm appears in that message box and is also that workbook's name.

Are they linked?

They appear to be linked through that SharePoint but I do not know why that message box does not appear when not enabled?

Do you have VBA code in the current workbook trying to open that other workbook?

Both documents have VBA code because they are the same document but are in different "locations". One being the cloud for the SharePoint and the other being the more traditional drive pathway.

Both documents are not communicating with each another through VBA code.

 

[Jaafar Tribak]

The message clearly says that the workbook is open already in another application so it must be open somewhere by some other software.

What happens when click on the message ok button? and what do you want to happen ?

Edit: Maybe this issue occurs due to the fact that the two workbooks have the same name. As you know, two workbooks with the smae name cannot be opened in the same excel instance... But then, it seems the other workbook is not open in the same instance so I am not sure why you are getting that popup message.

 

[Pinaceous]

The message clearly says that the workbook is open already in another application so it must be open somewhere by some other software.

What happens when click on the message ok button? and what do you want to happen ?

Edit: Maybe this issue occurs due to the fact that the two workbooks have the same name. As you know, two workbooks with the smae name cannot be opened in the same excel instance... But then, it seems the other workbook is not open in the same instance so I am not sure why you are getting that popup message.

Hi Jaafar,

Yes, the message does clearly say that the workbook is already open in another application.

My job is to force the other workbook closed and to keep the active workbook open free from that pop-up.

Any suggestions?

Thank you!
pinaceous

 

[Jaafar Tribak]

Hi Jaafar,

Yes, the message does clearly say that the workbook is already open in another application.

My job is to force the other workbook closed and to keep the active workbook open free from that pop-up.

Any suggestions?

Thank you!
pinaceous

Sorry, I have no idea why this happens, let alone how to fix it. Maybe someone else can help.

 

[Pinaceous]

Sorry, I have no idea why this happens, let alone how to fix it. Maybe someone else can help.

Okay I'll let you know how it turns out. Thank you for your input.

 

[Jaafar Tribak]

Okay I'll let you know how it turns out. Thank you for your input.

Thanks. I am curious to know.

 

[Pinaceous]

Hi Jaafar,

The "working" solution that I came up with was to totally expose that pop-up to force the user to interact with it.

After the pop-up has been disregarded by the user, then the AutoOpen continues.

If that pop-up is not linked by that document's location, then the code bypasses that part.

Basically;

CreateObject("Shell.Application").MinimizeAll

'AutoOpenCode

CreateObject("Shell.Application").UndoMinimizeAll

ThisWorkbook.Activate
ActiveWindow.WindowState = xlMaximized

Not sure what else I could come up with unless I could somehow block Excel's pop-ups that it provides backstage.

Thanks!
Pinaceous