Code stops after deleting a sheet

[Gautham A]

I'm writing the following code

Application.displayalerts= false
Sheets("L2_LookupTable"). delete
Sheets ("L2_Open_Incidents").Name="L2_LookupTable"
Sheets.add after:=Sheets ("Buttons")
ActiveSheet.name="L2_Open_Incidents"
Sheets("Buttons"). activate
Application.displayalerts=True

The code does not execute after 2nd line. It deletes L2_LookupTable sheet and does not execute after that. I'm not getting any error. Then if I press F8 it starts the code from first line

 

[Trevor G]

I have replicated this and it works.
Do you have any securities on the workbook? Are all the sheets visible?
In your code there are various words that aren't capitalising the first characters. I copied your code and it looks like this:

Sub check()
Application.DisplayAlerts = False
Sheets("L2_LookupTable").Delete
Sheets("L2_Open_Incidents").Name = "L2_LookupTable"
Sheets.Add after:=Sheets("Buttons")
ActiveSheet.Name = "L2_Open_Incidents"
Sheets("Buttons").Activate
Application.DisplayAlerts = True
End Sub

 

[Gautham A]

Hi Trevor,
Yes. All the sheets are visible. I typed the code on my phone. So only capital letters are missing. In vba I have written the code correctly.