Can a macro work in a protected [Excel 2010] sheet?

I am a records manager and I've created an Excel 2010 form for my users to complete when they are sending boxes of business records (paper) to offsite storage. I've created a macro via a commandbutton on the form that they can click to insert a new row each time they want to add a box (one row on the form equals one box of records, so 10 rows = 10 boxes). While the macro works really well when the sheet is not protected, it does not work when the sheet is protected.

How can I get around this... is there something I'm missing?

Here's my VBA code:

Private Sub CommandButton1_Click()

Sheets("RTL Form").Range("a13").Select
ActiveCell.EntireRow.Insert Shift:=xlDown

Sheets("RTL Form").Range("b13:G13").Select
Selection.Borders.Weight = xlThin

End Sub
Thanks.
Earl