Excel 10 Lock cell also locks ribbon

[tcebob]

I wanted to lock a single cell in a page, so I followed instructions in Help. The result was that the cell was locked, but so was the ribbon. How can I keep the ribbon alive?

 

[Drrellik]

you cant

anytime you use sheet protect to lock even one cell the ribbon is also protected as far as I know.

DR

 

[Michael M]

It also depends on what restrictions you placed on the protected sheet !
When you protected sheet there were a number of checkboxes you could have selected to allow users to do certain things.
When these are checked certain parts of the Ribbon are still active !