auto close msgbox

**CityMPLSEmpolyee** · 03-03-2011, 01:11 PM

I am opening a file with a macro and the file I am opening has a msgbox that opens right a way. I would like to close it so that my macro process can continue.
Can this be done?

Please Login or Register  to view this content.

**shg** · 03-03-2011, 01:58 PM

You can disable events before you open the file to prevent the workbook_open event from triggering.

Don't forget to turn them back on.

**CityMPLSEmpolyee** · 03-03-2011, 02:42 PM

I have tried something like that, but it did not work
Code I used was
Application.DisplayAlerts = False
Application.DisplayAlerts = True
Is this the same thing?

**mudraker** · 03-03-2011, 09:57 PM

What is the source of the message box and what inormation is it displaying.

i.e is it a macro generated or an Excel standard message like when you open a password protected or read only file

**CityMPLSEmpolyee** · 03-04-2011, 09:29 AM

the message box was made with a form and is displayed instinly when you open the file and it states the General Information about this file for those who refference it's data. like my selef.

This is the code that displays the message, but I can't change any thing in that file.
and This code is located in the folder “Microsoft excel object” and named “ThisWorkbook”

Please Login or Register  to view this content.

**shg** · 03-04-2011, 11:01 AM

Originally Posted by CityMPLSEmpolyee

Code I used was
Application.DisplayAlerts = False
Application.DisplayAlerts = True
Is this the same thing?

No.

Please Login or Register  to view this content.

**jwright650** · 03-04-2011, 11:18 AM

If the msgbox/userform is a necessary item, can you use a timer to display the msgbox/userform for say 5 seconds and then unload it and move on?

**CityMPLSEmpolyee** · 03-04-2011, 11:47 AM

first to Shg thank you your code worked,
and to answer jwright650
I don't have right permisstion to the file that I am reffernceing so I can't edit that code

Solved