Turn off MsgBox from Macro 1 when Running Macro 2

[Realtreegirl75]

I have a form that is filled out by field users on a daily basis. It has a couple of message boxes but the one giving me fits is instructions on how to change the date in the form when the file is first opened. Most of my field users are not very computer savvy so I need that message box to stay in place.

The issue comes on the back end. I have another macro that opens each report and converts the form to PDF and then closes the file. Each time it opens a file, that "change the date" macro pops up and you have to select OK before the macro can continue. Not a huge deal for 5 or 6 reports, kind of a pain for 90+ reports.

Is there a way to turn off those message boxes for certain users? Or automatically select OK while the macro is running so the user doesn't have to click it each time?

 

[Akuini]

Ok, what do you think of the suggested solution that I described in post #9?

 

[Realtreegirl75]

Basically, you just need to amend the code by adding a check whether workbook "Closeout" is open or not.

*EXACTLY* what I needed!! Works amazing, thank you so much!!

 

[Akuini]

You're welcome, glad to help & thanks for the feedback.