reading sheet

  • Thread starter Thread starter mgv
  • Start date Start date
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
 
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
 
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
 
I take your way but and on excel 2000 i go to unprotect sheet and this is
the message :

Remove protective sheet
 
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
 
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
Click to expand...
 
"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
 
Back
Top