Hi all!
Here's my code:
If Left(ws.Name, 5) = "Sheet" Then
ws.Delete
Problem is it it asks if i'm sure if i want to delete the worksheet whenever i run the code. How do i get rid of that confirmation so that it just deletes it without asking if I am sure?
Here's my code:
If Left(ws.Name, 5) = "Sheet" Then
ws.Delete
Problem is it it asks if i'm sure if i want to delete the worksheet whenever i run the code. How do i get rid of that confirmation so that it just deletes it without asking if I am sure?