On Protect Sheet screen, select Protect worksheet and contents of locked cells option > select the actions that you want to permit on this worksheet (Select Cells, Insert rows, Format Cells, etc) and click on OK to save the settings.Īfter this only the selected Cells will become locked in the worksheet and all other cells will be unlocked.Īlso, users will be able to work on the worksheet and perform all permitted actions that you had selected in Protect Sheet window. Next, click on the Review tab and click on Protect Sheet option in “Changes” group.ħ. In the Format Cells Dialog box, click on the Protection tab and select the Locked option.Ħ. In this case, we have selected Cells D2 to D5 to prevent others from making changes to Rates in the worksheet.ĥ. Now, select only the Specific Cells that you want to Lock and click on the dialog box launcher icon located in Alignment group of the Home Tab. In Format Cells dialog box, click on the Protection tab and uncheck the Locked box.Ĥ. Select the entire sheet and click on the dialog box launcher icon located in the “Alignment” Group of the Home Tab.Ģ. Lock Specific Cells in Excelįollow the steps below to Lock only certain selected or specific cells in Excel worksheet.ġ. Note: You will be required to enter a Password, in case the worksheet that you are trying to unlock was protected using a Password. In case you want to edit the Cells, you will have to first Unprotect the worksheet by clicking on Review tab > Unprotect Sheet. Once the worksheet is protected, all the Cells in the worksheet will be locked and Excel will display “The Cell or Chart you’re trying to open is on a protected sheet” message, whenever anyone tries to modify the worksheet. If you had typed a Password, you will be prompted to reconfirm the password. In the Protect Sheet box that appears, select Protect worksheet and contents of locked cells option > Enter a Password (optional) > select actions that you want to allow (Select Locked Cells, Select Unlocked Cells, etc) and click on OK.ģ. Click on the Review tab and then click on Protect Sheet option in the “Changes” Group.Ģ. By default, all the Cells in a Protected worksheet are locked.ġ. Lock All Cells in Excel WorksheetĪs mentioned above, you can Lock all cells in Excel by protecting the Worksheet. Luckily, it is also possible to Lock Specific Cells in Excel and this will prevent others from making changes only in those selected Cells. Users that open the workbook will have to enable macros.Hence, this method is not suitable if you are sharing the worksheet with others or you want others to be able to work on the worksheet.Save the workbook in a format that supports macros (.xlsm or.Set rngEdit = Intersect(Range("B2:B20,D2:D20"), Target) Private Sub Worksheet_Change(ByVal Target As Range)
HOW TO PASSWORD PROTECT CELLS IN EXCEL 2010 CODE
Copy the following code into the worksheet module:.Right-click the sheet tab, and select View Code from the context menu.If you specified a password, you will have to enter it again. Make sure that you remember this password! In step 3 below, I'll use If you want to set a password that will be needed to unprotect the sheet, enter it in the box.Press Ctrl+1 to activate the Format Cells dialog.In step 3 below, I'll use B2:B20 and D2:D20 as example. Select the cells that the users should be able to edit.
0 kommentar(er)
