ExcelBanter - Inserting a row into a locked sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Inserting a row into a locked sheet (https://www.excelbanter.com/excel-discussion-misc-queries/214040-inserting-row-into-locked-sheet.html)

BillS512

Inserting a row into a locked sheet

I'd like to lock an entire spreadsheet, but be able to add new rows and enter
data into the new cells. After the new data is entered, I would lock those
cells, too. Is this possible?

All times are GMT +1. The time now is 12:08 AM.