Delete Sheet In VBA Without Notification

Dear Friends, While automating in Excel through Excel VBA, you may want to delete or add some Worksheets. This is a very common task, which we try to do. I have already written an article where I have explained a lot about deleting worksheets using Excel VBA. In this article, I am going to teach you all about disabling the warning message while deleting a sheet using Excel VBA. While deleting a sheet from excel workbook, you get a warning message like shown in below image. This is a built-in warning message. This warning message is shown in both the case : Either you delete a sheet manually or VBA trying to delete a sheet. Delete-Warning-Message During VBA code execution, if you do not disable this notification, your program will wait until you press OK on this notification. Which is really not something you want. So, the question is how to disable this sheet delete notification using VBA. Solution: There is a very easy solution for this. All you need to do is – set […]