I have been making some changes to a sheet in my workbook (sheet template) adding in a new section in the worksheet changed event to update the format and unlock cells to allow people to fill in somewhere down the line it was working I'm not sure when, then after a few more changes it started to give me 1004 errors when assigning new values to cells, to the point where when running the sub test in module 4 on the template sheet

Sub test()
    Range("A1").Value = 0
End Sub
gives me a 1004 error

can anyone tell me why

_Main_Page.xlsm