Excel - Unprotect sheet command - How do I do this?

Asked By TK on 15-Oct-08 11:39 AM
I try to input data into a template my fried sent me. however it states..The
cell or chart is protected and is read only! To modify a protected cell I
must remove protection using the unprotect sheet command (review tab, changes
group). I may be prompted for password...which I have. HELP!




john replied on 15-Oct-08 11:44 AM
Tools|Protection|Unprotect sheet
--
John C
ShaneDevenshir replied on 15-Oct-08 11:44 AM
Hi,

if you are asking how do you unprotect a sheet:

1.  Activate the sheet
2.  Choose Review, Unprotect Sheet (in the Changes group)
3.  Enter the password and click OK.

--
Thanks,
Shane Devenshire
Don Guillett replied on 15-Oct-08 11:44 AM
Prior to xl2007
tools>options>>>

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
Mike replied on 15-Oct-08 11:46 AM
Hi,

Tools|Protection - Unprotect sheet

If you prompted for a password ask your friend or look here

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

Mike
Don Guillett replied on 15-Oct-08 11:45 AM
I meant tools>PROTECTION>>

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com