Protect a range of cells within a sheet

**SueMac** · 11-20-2012, 05:25 PM

How can I protect selected cells with formulas but not protect the whole sheet in excel 2010. I have searched the forum but nothing I have found works. The whole sheet gets protected and a user cannot make changes anywhere

Thanks in advance

**xladept** · 11-20-2012, 05:33 PM

Test for a leftmost equal sign in the Worksheet_SelectionChange event??

And, then if found:

Please Login or Register  to view this content.

**SueMac** · 11-20-2012, 05:43 PM

Sorry not sure what that means

**BB1972** · 11-20-2012, 06:50 PM

SueMac,

If you only have a few cells to protect, then select the entire sheet -> right-click -> Format cells -> Protection. UNcheck the "Locked" checkbox - this will "unprotect" (basically deselect) all the cells, should you chose to protect your sheet.

Then, selecting only the cells you want protected, follow the above procedure, but this time, check the "Locked" box.

When you now apply password protection to your entire sheet, only the cells where you have selected "Locked" will be protected.

**xladept** · 11-20-2012, 08:42 PM

That didn't work anyway - try this instead:

Please Login or Register  to view this content.

or you could select a "safe" cell.

**SueMac** · 11-21-2012, 01:22 PM

Thank you Brendan, that worked perfectly!

**BB1972** · 11-21-2012, 05:45 PM

Glad to help, Sue.

If your query has been answered to your satisfaction - as it appears to be - could you please mark this thread "solved". Thank you.