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()
Selection.Borders.Weight = xlThin