Protecting Cells In A Worksheet
 

Have followed all the directions to protect certain cells in a worksheet.
After unlocking the cells in the entire sheet I get the following dialogue
box "Too many different cell formulas" and the cells don't get unlocked.

Any suggestions??


--
Nicole

Protecting Cells In A Worksheet
 

You sure it says "formulas" and not "formats"?

Maybe this KB Article will shed some light if "too many formats"

http://support.microsoft.com/default...b;en-us;213904


Gord Dibben MS Excel MVP

On Wed, 9 Dec 2009 08:05:01 -0800, Nicole
wrote:

Have followed all the directions to protect certain cells in a worksheet.
After unlocking the cells in the entire sheet I get the following dialogue
box "Too many different cell formulas" and the cells don't get unlocked.

Any suggestions??