Jun 27 2021 07:56 PM - edited Jun 27 2021 08:01 PM
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
Jun 28 2021 12:02 AM
Try adding a line
Application.DisplayAlerts = False
at the beginning of the macro, and
Application.DisplayAlerts = True
at the end of the macro.
Jun 28 2021 01:17 AM