Ignore MsgBox in a referenced Workbook

[tv69]

Hello,

I have workbooks A, B, C.

Via the 'Sub Workbook_Open()' in workbook A, workbook B is opened as read only and it is checks for any new rows of orders. If new orders are found, a message box pops up to inform the user.

Via the 'Sub Workbook_Open()' in workbook C, workbook A is opened as read only to search for new cell data and synchronize corresponding data in workbook C. During this process, the message box pops up once again when workbook A is opened.

Is there a way to ignore or bypass the message box of workbook A when workbook C is being opened?

I have tried Application.DisplayAlerts = False but that does not work.

Cheers,

TV

[moonsaga]

Can you upload a sample workbook with the code ... make sure all sensitive data is removed.

[gsnidow]

tv69, if it is a message box, you could easily turn it off. However, without seeing the code, it's kind of hard to give you advice. Could you post the code?

Greg

[tv69]

Thanks for the interest guys and sorry for the delay in getting the docs uploaded here.

Here are the 3 docs, docA, docB, docC

Opening docA checks docB and pops up a message box.

Opening docC and pressing the macro button, causes docA to be opened to attempt to get some dates synchronized. As when docA is opened on it's own, the message box appears and halts the macro from completing.

It would be ideal to keep the message box but to bypass it when running the macro in docC.

Thanks for any help.

TV

[moonsaga]

Try this .. this code is from workbook C..

Please Login or Register  to view this content.

[tv69]

Eureka moonsaga!!

That works perfectly. Thanks very much. I just looked up more info and understand its use. Always learning...

Thanks again.

TV

[moonsaga]

Your welcome.. Happy to help..