Forum Discussion

RowingCatP's avatar
RowingCatP
Copper Contributor
Jun 28, 2021

How can I always select yes automatically

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

  • RowingCatP 

    Try adding a line

     

    Application.DisplayAlerts = False

     

    at the beginning of the macro, and

     

    Application.DisplayAlerts = True

     

    at the end of the macro.

    • RowingCatP's avatar
      RowingCatP
      Copper Contributor
      I have written this function in my code but still jump the msgbox.
      Need more help

Resources