I have a worksheet in Excel which is protected but allows the user to add rows as needed (thanks to Ture). I just found out that when it adds rows, the rows are locked because that is the Excel default. Here is the VBA as it is. I need to add some lines that will unlock the cells in the added rows.
If TypeOf Selection Is Range Then
If Selection.Rows.Count = 1 Then