How can I always select yes automatically

Copper 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

lADPBFDk_FG_48bNAj7NBGU_1125_574.jpglADPBE1XfazYMybNAtDNBQA_1280_720.jpg

2 Replies

@RowingCatP 

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