Protecting a worksheet question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a question for Excel 98.

I tried to do a simple worksheet protection and provided a password. However, I found that not ALL cell in that particular worksheet was protected. Most of the cell would give you a message telling you the worksheet is protected and you need to unprotect the worksheet to modify the cell content. However, some cells you can still change its content. What are the reasons these things happen?

Thank you!
 
Each cell has a locked property that you can toggle. But the "lockedness"
doesn't really do anything until the worksheet is protected.

Then locked cells are, er, locked and can't be changed.

Unlocked cells can change.

I think most people lock the cells that contain formulas that shouldn't be
modified--and maybe labels/values, too.

And they leave the cells that need to have values entered unlocked.

Format|Cells|protection tab
is where'd you find that Locked option.
 
By default, all cells are locked. In Windows, you select cell(s) and
Format>Cells>Protection>Unlock. The locked/unlocked status is invoked when
the sheet is protected, with or without a password. The cells in your ws
which you may modify have been unlocked prior to the sheet protection beiing
set, I would guess.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
James said:
I have a question for Excel 98.

I tried to do a simple worksheet protection and provided a password.
Click to expand...
However, I found that not ALL cell in that particular worksheet was
protected. Most of the cell would give you a message telling you the
worksheet is protected and you need to unprotect the worksheet to modify the
cell content. However, some cells you can still change its content. What
are the reasons these things happen?
 
Back
Top