reading sheet


M

mgv

We have receved a sheet from a collegue and in one of cell I try to write a
text but i have a message " cell protected remove protection"
I ask to my collegue the password to solve the protection but he say me that
there isn't any password . On our computer he can read an modify cell
without problem.
Why ?
Is possible to have some different settings ?
Someone acn help me to write in cell??
thanks
 
Ad

Advertisements

G

Gord Dibben

Are you sure sheet protection is passworded?

Do you get a message asking for a password or just a message that the cell
is protected?

If the latter, simply unprotect the sheet.

If the former, see this site for info on removing sheet protection
passwords.

http://www.mcgimpsey.com/excel/removepwords.html


Gord Dibben MS Excel MVP
 
M

mgv

this is the message
the cell or chart you are editing is protected and therefore read-only
 
G

Gord Dibben

And what message do you get when you attempt to unprotect the worksheet?

Does Excel ask for a password?

Excel 2003 Tools>Protection>Unprotect sheet.

Excel 2007 On Ribbon>View>Unprotect sheet.


Gord
 
M

mgv

I take your way but and on excel 2000 i go to unprotect sheet and this is
the message :

Remove protective sheet
 
G

Gord Dibben

I have never seen a message with that particular wording.

If no password, the sheet will become unprotected without any message when
you go to Tools>Protection>Unprotect sheet.

If asked for a password, you must supply or use a method found on JE
McGimpsey's site to remove it.

If you want, send me the workbook by email.

Change the AT and DOT in my email address.


Gord
 
Ad

Advertisements

M

mgv

i have try to sent email but i can't .
Gord Dibben said:
I have never seen a message with that particular wording.

If no password, the sheet will become unprotected without any message when
you go to Tools>Protection>Unprotect sheet.

If asked for a password, you must supply or use a method found on JE
McGimpsey's site to remove it.

If you want, send me the workbook by email.

Change the AT and DOT in my email address.


Gord
 
Ad

Advertisements

G

Gord Dibben

"can't" means what?

You don't know how to change my email address or you have no email client?

If the former........Do you see my address just below in the header?

Looks like this.....................gorddibbATshawDOTca

Change the AT and DOT to appropriate punctuation.


Gord
 

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

Top