Vba delete sheet no warning


Re: How to Delete Excel Sheet without Warning - MFC Or just copy over the old data without deleting or clearing it, then adjust the series to point to the new data and adjust any residual. When you execute this code, Sheets.Add will work without any prompt but when compiler will come to ActiveSheet.Delete it will prompt a message like this. Since you are deleting sheets using VBA, you know what you are doing. You would like to tell Excel not to show this warning and delete the damn sheet. Any uncommitted changes made to the local list are not sent to the SharePoint list. There is no warning that these uncommitted changes are lost. Support and feedback. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. However, I get a warning regarding the delete. The problem is I'm opening the worbook from access and not excel therefore... Delete Sheet in Excel without Warning from Access VBA Any uncommitted changes made to the local list are not sent to the SharePoint list. There is no warning that these uncommitted changes are lost. Support and feedback. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.