Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lock only specific cells and ranges in a protected worksheet 2007

Status
Not open for further replies.

feajob

Aerospace
Joined
Aug 19, 2003
Messages
161
Location
CA
Hi,

I would like to know how to enable cells to be edited while leaving only some cells locked. I could do this task in excel 2000, but I have difficulty to perform this task in excel 2007. I appreciate your help.

Thanks,
A.A.Y.
 
Isn't this much the same as always?
Select cells and press Ctrl 1.
Go to protection tab and unlock selected cells.
Under /Review\ tab on the ribbon select protect sheet/workbook.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top