protection in excel and sum command

[Tom]

I want to protect a single cell in a spreadsheet from
being changed. I want the spreadsheet to function
normally in every other respect. When I turn protection
on certain function on my menu like sum are grayed out and
are not available through the shortcut. How do I stop
excel from doing this while still protecting that one cell?

 

[Tom]

Alan,

Doing this does not solve my problem. This is in fact
what I have done. When you do this certain shortcut
funcions on the menu like sum are not available at all.
Yes the protection works but the functions do not