Editing Unlocked Cells in Protected Sheet

  • Thread starter Thread starter Larry Hau
  • Start date Start date
L

Larry Hau

When I protect a sheet in Excel 2000, and go to an
unlocked cell, many of my toolbar buttons are grayed out
and can't be used. For example, I cannot underline an
unlocked cell. Is there a way to protect a sheet without
impacting the ability to edit unlocked cells? Thanks for
your help.

Larry Hau
 
It's true that you cannot format unlocked cell in Excel 2000 when a
worksheet is protected. It's just a limitation or a design decision. I
know it's no help but fyi in Excel 2002 protection was fine-tuned to give
you greater control over things like this.
 
Back
Top