Preparation:
1) Unprotect the worksheet
2) Select all cells on the sheet
3) CTRL-1 > Protection > UNLOCK them > OK
4) Select all cells
5) Press F5 (Goto) > Special > Constants> OK
6) CTRL-1 > Protection > LOCK the selected cells
7) Select all cells
8) Press F5 (Goto) > Special > Formulas > OK
9) CTRL-1 > Protection > LOCK the selected cells
Now the sheet is ready to automate.
Open the VB editor and put this macro into the ThisWorkbook module, be sure to edit it to process the correct sheet name:
The way this works is that any unlocked cell on that sheet is fully editable until the user closes the workbook. At that moment the updated cells are locked and become uneditable.
Bookmarks