Hi
The concept is to lock the cell containing the formula however leave those cells with the precedents for client data entry. ie if the formula was:-
Cell A1 = B1+C1 then lock A1 but leave B1, C1 unlocked. Your client can then change either B1 or C1 and the formula will still calculate. Have a look at the options available by
1. Right click the cells and select Format Cells , then Protection to either lock or unlock
2. Protect Worksheet on the Excel "Review" tab and a range of options are presented where you can tick a box to select whether the cell s effectively locked. Note you can protect formula, and by selecting any combination of options effectively control what can be done on the spreadsheet..changing formula.. adding rows.deleting rows etc.
To be effective the sheet protection needs to include a password else anyone can change the controls. however if you use a password do not forget it. There is no help readily available should you forget.
Cheers
Bookmarks