Many functions become unavailable when sheets are protected.

You can enter a SUM function in an unlocked cell, just can't use the Autosum.

For functions like Bold and other formatting make sure when you protect the
sheet that you have Allow users to "Format cells" enabled.


Gord Dibben MS Excel MVP

On Mon, 24 Mar 2008 12:46:00 -0700, ron wrote:

I'm protecting individual spreadsheets by locking certain cells and then
going to tools and doing protection and protect worksheet, but when I do
that, the autosum icon lightens and is inoperable. I only want certain cells
protected and want to be able to use all the icons on the bars (fomating,
bold, autosum) and would like to know how to accomplish that.

Thank you for any assistance.