Delete sheets in VBA without asking me to confirm

**jpbalky** · 11-23-2011, 11:48 AM

Hi,

If I want to delete a sheet, I always get a mesage to confirm this action and it stops the macro untill I give a response.

"Data may exist in the sheets(s) selected for deletion. To permanently delete the data, press Delete"

This is the way I currently perform this action:

ActiveWindow.SelectedSheets.Delete

JP

**Andy Pope** · 11-23-2011, 11:50 AM

switch DisplayAlerts off first.

Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True

**jpbalky** · 11-29-2011, 08:56 AM

Thanks that worked great. I can even apply this to more items I had, when replacing files when saving a file which already existed. Till now I almost emptied the map first beofre I ran the macro.

JP