How can I automatically lock data after it has been entered into mulitable cells of a worksheet without having to set a password and unlocking and relocking each time.
I need to add data to the worksheet in say col A, B, 7 C then at a latter date add additional data to the row in say col E, F, & G the firsts set of data will cause a calculation in say col H then the second set of data may or may not cause col H to recalculate.

I would need to apply this across 14 worksheets in the single workbook which is used by multiable people.

CAN THIS BE DONE?????