Any Excel gurus out there?

[Dutchy]

How do I protect a cell in a spreadsheet (I have a formula that I dont want tampered with) I know how to protect the whole spreadsheet but I dont want to do that I just want one cell protected

Any help please?

[grant j]

Go to format cells and select protection.

that should do it

[smac]

You will then need to enable sheet protection for that to work.

An alternative would be to put the formula in a selectionchange macro that would add that formula to that cell anytime someone changed that cell. Sounds difficult, but it isn't. PM if you want a hand.

[Dutchy]

Thanks Gents all done