{"id":12079,"date":"2011-11-06T05:26:12","date_gmt":"2011-11-06T05:26:12","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=294"},"modified":"2017-10-08T02:23:45","modified_gmt":"2017-10-08T02:23:45","slug":"delete-sheet-in-vba-without-notification","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/11\/delete-sheet-in-vba-without-notification\/","title":{"rendered":"Delete Sheet In VBA Without Notification"},"content":{"rendered":"
Dear Friends,
\nWhile 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.<\/a>
\nIn this article, I am going to teach you all about disabling the warning message while deleting a sheet using Excel VBA.
\nWhile deleting a sheet from excel workbook, you get a warning message like shown in below image. This is a built-in warning message.
\nThis warning message is shown in both the case : Either you delete a sheet manually or VBA trying to delete a sheet.<\/strong>
\n