I'd like to know if there's a way of locking a certain cell so that noone can overwrite the formula that's in it. I have Excel 97 and have created a sheet where several cells contain formulas. My collegues at work don't always seem to understand that these cells should NOT be typed in. Is there an easy way to protect a cell from writing in it (I'd rather not make a macro funstion or password lock the whole sheet. Also the cells should not be hid as they sometimes show important inforamtion). Cheers/

Yes. Select a cell, right-click and choose "Format Cells...". Select the Protection tab. Make sure "Locked" is checked. Click Ok. From the main menu, choose "Tools" - "Protection" - "Protect Sheet..." Make sure that at least "Contents" is checked. Add a password if you want - you don't have to. Hey presto, every cell is locked. Clearly this isn't quite what you want, so.... Before you do this, unlock every other cell on the sheet. (Fortunately you can select them all at once and do this.) If you don't want people to see your formula - at the screen where you chose "Locked", also choose "Hidden". This will only hide your formula, and not the result. Cheers Tom