skip popup window

  • Thread starter Thread starter bris
  • Start date Start date
B

bris

Hi

I'm having a macro that do some web updates and put it in a new worksheets.
After I've been copied the information I need, I delete the added worksheet,
by using:
ActiveWindow.SelectedSheets.Delete.
But this code initiate a popup window asking if you really wants to delete.
Is there a way of disable this popup window?

Br.
Brian
 
Add the line:

Application.Displayalerts = False

Don't forget to reset it back to true afterwards!
 
Back
Top