Confirm Delete in a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a macro that I am using, I need to delete a sheet. When I record the macro and then replay it, it brings up the confirmation dialog again. How can have the macro automatically confirm deletion of the sheet.
 
Tim

Sub test()
Application.DisplayAlerts = False
Sheets("Sheet1").Delete
Application.DisplayAlerts = True
End Sub


--
XL2002
Regards

William

(e-mail address removed)

| In a macro that I am using, I need to delete a sheet. When I record the
macro and then replay it, it brings up the confirmation dialog again. How
can have the macro automatically confirm deletion of the sheet.
 
Tim

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


Regards

Trevor


Tim said:
In a macro that I am using, I need to delete a sheet. When I record the
Click to expand...
macro and then replay it, it brings up the confirmation dialog again. How
can have the macro automatically confirm deletion of the sheet.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

getting rid of the "confirm delete" dialogue box when deleting a s 5
another macro query - deleting a worksheet within a query 2
How to avoid delete confirmation 1
Confirm a choice before Macro 3
Excel 2007: Help creating a macro that will run Solver? 3
Macro question 5
don't confirm deletion of a sheet with macro 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0

Back
Top