Hello,

I have a workbook that needs to be password protected but I want the user to be able to fill in the next available range of cells.

I want everything else besides the available cells at the bottom to be protected. As they fill in columns A-V I want those cells to also automatically be locked so they cant be changed.

eg... Columns A-V have things that need to be filled out.. (Date, Name, Price etc...). In row 1-1000 are all previous entries so they are already protected when the file is opened. When the next person comes to fill out the sheet I want them to be able to go to row 1001 and be able to fill in their entries but as soon as they are done I want row 1-1001 to be password protected automatically.

I know how to do this cell by cell but i don't want the user to have to click "okay" after clicking every single cell.

Anyone know how to do this?

Thanks!