MrExcel Publishing
Your One Stop for Excel Tips & Solutions

diabling the delete dialog


Posted by John Buckley on July 17, 2001 12:55 PM

I am creating a VB application that will open an excel template, create a range of dates for a quarter period that will be written to the only worksheet found in the template and then copy the worksheet for each test to be maintained for the customer. Each test sheet will be renamed with the appropriate test name for the worksheet name property and then the origanl worksheet will be deleted before saving the file. My question is how do you disable the dialog that comes up asking if the user is sure they want to delete the sheet? I've done this before but can't remember exactly how I did it.


Posted by Dax on July 17, 2001 1:06 PM

Easy...

Application.DisplayAlerts=False

Dax.