Channel: TeachExcel

Category: Education

Tags: hide excel confirmation windowprevent excel popupsprevent excel alert windowsstop excel alerts

Description: Full VBA Course: teachexcel.com/vba-course-update.php?src=youtube_v_description_JuBY9_jQQJA VBA Quickie Playlist: youtube.com/playlist?list=PLxhsXZXQXrUDjjYmKn5Wi3V6dkyjGpV9q Let's make our macro and VBA programming life a bit easier by turning off those pesky pop-up alert windows that ask for confirmation before completing certain actions. This tip allows you to do things like this (without requiring confirmation): - Overwrite existing files using macros and VBA. - Delete worksheets using macros and VBA. - Changing file types and extensions using macros and VBA. - Pretty much anything else that requires a confirmation. Note: Turning off alert pop-up windows in Excel will cause the default option from the alert window to be selected - usually this results in the desired action being performed, but please test your code on sample files first, to ensure you don't lose any data. To automate your Excel workbooks (and save hours of time), checkout my Full VBA Course: teachexcel.com/vba-course-update.php?src=youtube_v_description_2_JuBY9_jQQJA #msexcel #vba #tutorial