I am deleting worksheets in vba by using the line:
worksheet("Sheet2").delete
However Excel displays a warning box that it is about to delete a sheet. At which point user can presss cancel, which is not something I want user to do.
Is there any way to stop Excel from displaying the message box.
Thank you for your help.![]()


Reply With Quote