I have a sheet in a workbook that is prompting me for a password whenever I insert a row.
It is the only sheet in the workbook with this problem.
It happens with new rows and when I copy a row and try to insert.
As far as I know I have removed all locks and protection from the worksheet.
Is there a macro or other way to remove all protection from the sheet? I don't want to be prompted for a password when inserting rows.