Table expansion protected data

I have a table that has worked for 3 years and even though protected at end of each sort macro it will no longer expand to give me an unprotected line to add new data.  I have tried the auto correct option to add new line but did not help.  Excel 360 windows 10