I want a marco to run before the workbook save:
The macro must check in every sheet the cells I1 to I50
and if there is a value inside the checked cell , it must lock
the row .

Example if it finds a word at cell I38 i want the macro to lock Row(38).
Please help me