ExcelBanter - Delete a Worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Delete a Worksheet (https://www.excelbanter.com/excel-programming/322570-delete-worksheet.html)

Andym

Delete a Worksheet

Hi All
I have a macro that has to delete a worksheet but when it runs the pop box
asks if i am sure, can this be turned off in the macro so it deletes without
asking for verification???

Thanks

Ben

Delete a Worksheet

application.displayalerts = false

"Andym" wrote:

Hi All
I have a macro that has to delete a worksheet but when it runs the pop box
asks if i am sure, can this be turned off in the macro so it deletes without
asking for verification???

Thanks

All times are GMT +1. The time now is 10:19 PM.