Hello,
I have this code, so simply add a line when a object button is pushed. However, I want to password protect the sheet, and naturally this vba does not work then. How do I write in a code that will allow for the rows to be inserted?
I have this code, so simply add a line when a object button is pushed. However, I want to password protect the sheet, and naturally this vba does not work then. How do I write in a code that will allow for the rows to be inserted?
VBA Code:
Sub addline()
'
Rows("23:23").Select
Selection.Copy
Rows("24:24").Select
Selection.Insert Shift:=xlDown
End Sub