I have a workbook with 5 sheets which are full of formulas and I need to make them safe uneditable. I have found through Stackoverflow a simple code that protects formulas and it’s working perfectly but it affects the other codes in my workbook not to run properly such as inserting images based on a cell value – my images stopped to be updated when I change a cell value. and also gives me error(1004) when i edit some unlocked cells but included in other codes ranges.. I dont know how to fix that. any sugesstions please ?… here in below my code

I have a workbook with 5 sheets which are full of formulas and I need to make them safe uneditable. I have found through Stackoverflow a simple code that protects formulas and it’s working perfectly but it affects the other codes in my workbook not to run properly such as inserting images based on a cell value – my images stopped to be updated when I change a cell value….and I dont know how to fix that. any sugesstions please ?… here in below my code