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
Bookmarks