Prevent message boxes from another macro from popping up

Hey everyone, so I currently have a macro that leads two other codes to run. I put these codes into my current macro using Application.Run. The problem I am running into is that the two macros that I am running contain message boxes within them to let the user know the macro is done. The macro I am working on now is supposed to make the process quicker but when the messages boxes come up and the user has to click ok or hit enter, it adds a lot of time to the process. This script could sometimes be used to run each of the other programs hundreds of times. I have tried putting Application.DisplayAlerts=False into the code so that it prevents these other boxes from appearing, but they still come up. Can anyone help with this? I would get rid of the messages inside the two scripts I am running, but I need those for when they are run on their own. I'll try to explain better below by showing you what I'm working with.

Please Login or Register  to view this content.

Basically I am running two programs based on a list of values that are set in row 4. The values start in cell I4 and carry on to the right. The two macros I am running inside of this one both depend on the value of cell I4. So the code takes the value of I4, runs "CreateSL" and "NewFileSL" and then deletes that cell so that the next item in the list moves into I4. The code does this until I4 is empty. My problem is that both "CreateSL" and "NewFileSL" contain message boxes at the end of their code. I would prefer not to comment out these message boxes each time I want to run this script because they need to be there for times when these scripts are run by themselves.

Any help is greatly appreciated, thanks.

Hello sczerniak,

Application.DisplayAlerts only works with dialogs that are generated by the system, not by individual macros or other applications. You will need to edit the other macros to stop the messages.

Would it be possible to include If statements into my two other codes so that the messagebox doesn't appear while my code is running?
something along the lines of:

Please Login or Register  to view this content.

Forgive my crude coding here

Hello sczerniak,

Can you post the code for the other 2 macros?

I think you want this...

Please Login or Register  to view this content.

Hello sczerniak,

I have commented out the messages from the code. You can copy and paste this code over the qoriginal.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hello sczerniak,

Post your workbook and I will see what I can to do to make that happen.

Hello sczerniak,

I changed CreateSL and NewFileSL to take a boolean argument. The default is false which allows the message to be displayed. In the macro SaveAllSL, the value is passed in as True to prevent the message from displaying. The atached workbook has the updates.

Hello sczerniak,

There are in the same place as the old macros. The only thing I changed was adding a argument named bHideMsg and adding a If statement to the message.

Hello sczernia,

That's true. Excel hides any Sub procedure macro that has arguments.

Hello sczerniak,

Just like you always have done by including the macro name in your code and using the VB Editor (ALT+F11) to make changes.

Hello sczerniak,

You will need to create 2 new macros to call theses macros. Your 2 new macro will show up in the Macro dialog. Rename these to what you want.

Please Login or Register  to view this content.