I'm using VBA to delete a worksheet in Excel. Each time I delete a worksheet, Excel produces a message box with the following warning:
The selected sheet(s) will be permanently deleted.
To delete the selected sheets, click OK.
To cancel the deletion, click Cancel.
Is there a way to bypass this warning using VBA? The code I'm currently using is as follows:
Sheets("Summary".Select
ActiveWindow.SelectedSheets.Delete
The selected sheet(s) will be permanently deleted.
To delete the selected sheets, click OK.
To cancel the deletion, click Cancel.
Is there a way to bypass this warning using VBA? The code I'm currently using is as follows:
Sheets("Summary".Select
ActiveWindow.SelectedSheets.Delete