Automatically select option on pop-up dialog box

BIMguy

New Member
Joined
Mar 19, 2021
Messages
5
Office Version
  1. 365
Platform
  1. Windows
I'm using the following code and it works great except for the dialog box that pops up for each sheet deleted.
How can I edit the code do automatically select the delete button on the pop-up

Sub Delete_Multiple_Excel_Worksheets()
Set ws1 = Worksheets("Parameters").Range("D2")
Set ws2 = Worksheets("Parameters").Range("D3")
Set ws3 = Worksheets("Parameters").Range("D4")
'delete three worksheets at the same time
Worksheets(ws1.Value).Delete
Worksheets(ws2.Value).Delete
Worksheets(ws3.Value).Delete
End Sub

1616504572394.png
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
add this before delete
Application.DisplayAlerts =False
and turn back on after all sheets are deleted
Application.DisplayAlerts = True
 
Upvote 0
Solution

Forum statistics

Threads
1,214,911
Messages
6,122,199
Members
449,072
Latest member
DW Draft

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top