Protected worksheet error

T

Teodoro

Hi,
in my installation of Excel 2003 something unwanted
happens: if the worksheet is somehow protected, even if I
try to access unprotected cells, that is cells on wich I
can write, on every cell I try to access I'm prompted to
provide a password.
I repeat: on every cell I'm prompted to provide a password.
This is very ennoying (as you can imagine).
I even tried to re-install Excel 2003, but with no success.
Any suggestion ?
Thanks
Teodoro Marinucci
 
G

Gord Dibben

Teodoro

Tools>Protection>Allow Users to Edit Ranges.

Perhaps you have passworded the entire sheet as a range.

Clear/delete any permissions you have set.

Gord Dibben Excel MVP
 
T

Teodoro Marinucci

Perhaps my initial post was unclear.
1. The entire sheet is NOT protected.
2. Only some cells are protected.
3. I'm prompted to provide a password even when I try to
access NON protected cells.
Thanks
Teodoro Marinucci
-----Original Message-----
Teodoro

Tools>Protection>Allow Users to Edit Ranges.

Perhaps you have passworded the entire sheet as a range.

Clear/delete any permissions you have set.

Gord Dibben Excel MVP
Click to expand...
 
D

Dave Peterson

I think that excel uses the term Locked/unlocked with ranges/cells. And
Protected/unprotected with worksheets.

And I'm still slightly confused at what #1 means--all the cells are not locked
or the worksheet is not protected. But that's not important (yet).

I use xl2002 and if the worksheet is protected and I've allowed users to edit
locked cells with a password, then I get the password prompt when I attempt to
change one of those cells.

But I don't get the password prompt if the cell is unlocked (on a protected or
unprotected worksheet).

Any chance that that password prompt is the result of a developer's macro?
Maybe there's an event macro hanging around waiting for you to make a change and
then verify who you are.

I'd try opening that workbook with macros disabled to see if that gets rid of
the problem.

One way to disable macros is to open excel in safe mode:

Close excel
Windows start button|Run
excel /safe

File|open the workbook and see what happens.

Teodoro said:
Perhaps my initial post was unclear.
1. The entire sheet is NOT protected.
2. Only some cells are protected.
3. I'm prompted to provide a password even when I try to
access NON protected cells.
Thanks
Teodoro Marinucci
Click to expand...
 
Top