I need code to be able to unprotect sheet add a row at a select selected place and then protect the sheet as before but leaving the new rows unprotected.
Would this best be done with a macro. I would also need to add a tool bar button or right click option (prefered) to do this.
Any help on this would be most appreciated. I am using Excel 2002 at the moment.