I do not want user to be asked. Instead I want the worksheet "Report"
to be deleted automatically.

Can anyone please advise if there is a command to "force" delete the
worksheet without asking the confirmation from user?

Application.DisplayAlerts = False
Worksheets("Report").Delete
Application.DisplayAlerts = True
HTH,
Merjet