I use the following Macro for inserting row
Sub Insert_Row()
With ActiveCell.EntireRow
If .Row <> 1 Then
.Offset(-1).Copy
.Insert
On Error Resume Next
.Offset(-1).SpecialCells(xlCellTypeConstants).ClearContents
End If
End With
End Sub
Than I protect my sheet with password but allowing to insert rows.
Though it doesn't allow me to do so and get following error in macro with "insert" marked in yellow
Sub Insert_Row()
With ActiveCell.EntireRow
If .Row <> 1 Then
.Offset(-1).Copy
.Insert
On Error Resume Next
.Offset(-1).SpecialCells(xlCellTypeConstants).ClearContents
End If
End With
End Sub
How can I insert row to a sheet that is protected with password?
Bookmarks