ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   unprotect specfic cells in worksheet (https://www.excelbanter.com/excel-worksheet-functions/214933-unprotect-specfic-cells-worksheet.html)

ND at sib

unprotect specfic cells in worksheet
 


Shane Devenshire

unprotect specfic cells in worksheet
 
Hi,

With protection off, select the cells you want to unprotect and then choose
the command Format, Cells, Protection tab, and uncheck Locked. Then
reprotect the sheet.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"ND at sib" <ND at wrote in message
...


JE McGimpsey

unprotect specfic cells in worksheet
 
Select your specific cells. Choose Format/Cells/Protection, uncheck the
Locked checkbox.

In article ,
ND at sib <ND at wrote:

JBeaucaire[_10_]

unprotect specfic cells in worksheet
 

Select the cell(s), press Ctrl-1 to access the Format properties, select
*Protection* and uncheck the "locked" box.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45160



All times are GMT +1. The time now is 04:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com