Hi Team,

I would like to lock all the formula cells in the master workbook upon entering formula and all the existing formulas. Also, there is a macro in the master file to split the existing workbook into many workbooks based on employee id. Would it be possible to lock all the formula cells even in the individual files upon splitting.


Please help…. Your help would be really appreciated!!



Thanks,
Vignesh