Assuming you've already manually set the locked status of the cells you want, there's no need to redo those. What you really need is for the workbook to set a secret flag called "UserInterfaceOnly:=True" on the product listing each time the workbook is opened. That flag allows the sheet to stay protected, but most macro code can run freely on the sheet without unprotecting it first.
So, I put this in your ThisWorkbook module to do that when the wb is first opened:
I also corrected the formula in F234. With that, the macro seems to be working fine now.
Bookmarks