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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change format protection default to unlocked? 2
How unlock locked cells 2
Edit/Fill/Series on Protected Sheet 1
Excel 2003 Regarding Cell Protection 1
Scope priviledges for locked/unlocked cells 2
Excel 2000 help please - Cell protection 2
Protecting Worksheet - Cannot move between cells. 2
hide columns on a protected sheet??? 1

Back
Top