DELETING A WORKSHEET USING VB AND stopping the popup request

[jdavis9]

I am using a macro to delete a worksheet.

can you prevent the popup telling you its going to delete?

activewindow.selectedsheets.delete is what I use now.

 

[TommyGun]

Re: DELETING A WORKSHEET USING VB AND stopping the popup req

Set DisplayAlerts to False...

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> DeleteSheet()

Application.DisplayAlerts = <SPAN style="color:#00007F">False</SPAN>

ActiveWorkbook.SelectedSheets.Delete

Application.DisplayAlerts = <SPAN style="color:#00007F">True</SPAN>

<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN>

</FONT>

 

[Juan Pablo González]

Re: DELETING A WORKSHEET USING VB AND stopping the popup req

Use

Application.DisplayAlerts = False
'your code
Application.DisplayAlerts = True