Msg Box stopping Macro from running

[Brazz1]

Hi,

I am looking for help with a Macro I created. The macro opens 12 other workbooks and copies dynamic data from each workbook. The issue I have is twofold, I created a Msg Box that tells the user "This Workbook will close in 15 mins" and then excel dialogue box opens up and asks me if I want "Save my changes" at the end of each workbook.

So when I run the Macro, it open the workbook, the message box appear, I have to OK for it to move to the next phase and when I have completed my task within that workbook, excel asks “Do I want to Save the changes”, so I have to click No, Not to save any changes.

So I have to click the through Macro 24 times for it to run correctly.

It there any way I can I bypass these pop ups by using some code? Any help or suggestions are greatly appreciated.

Rgd’s

 

[Norie]

You could temporarily disable events as these other workbooks are opened/closed.

Application.EnableEvents = False

' code to open/close workbooks and do stuff

Application.EnableEvents = True

If you want to stop the 'save changes' prompt either close the workbooks with SaveChanges:=False or temporarily disable alerts.

 

[Rick Rothstein]

Another option is to use the Status Bar for your messages... not as "visible" as MessageBoxes but they do not interfere with the flow of code...

Application.StatusBar = "Hello"

 

[Brazz1]

OK, folk's thank you for the response I shall try both options and get back to you

 

[Brazz1]

Re: Msg Box stopping Macro from running..Solved

Folk's sorry for the slow response. I have only been able to test your imputs today and they work perfectly. Thank you so much