How can I always select yes automatically

New Contributor

As title, it comes up every time when I was running VBA. Is there any solution to fix it or jump the msgbox? I want it always Yes (determine) for all excel files.
Sorry about the picture, language version problem


2 Replies


Try adding a line


Application.DisplayAlerts = False


at the beginning of the macro, and


Application.DisplayAlerts = True


at the end of the macro.

I have written this function in my code but still jump the msgbox.
Need more help