Forum Discussion
RowingCatP
Jun 28, 2021Copper Contributor
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 v...
HansVogelaar
Jun 28, 2021MVP
Try adding a line
Application.DisplayAlerts = False
at the beginning of the macro, and
Application.DisplayAlerts = True
at the end of the macro.
- RowingCatPJun 28, 2021Copper ContributorI have written this function in my code but still jump the msgbox.
Need more help