In the Format Cells dialog box, on the Protection tab, clear the Locked checkbox, and then click OK : 4. on the popup menu: On the Home tab, in the Cells group, click Format, and then click Format Cells. To edit these cells, you have to unprotect the sheet. Select Protect Workbook, then Encrypt with Password from the dropdown menu. Do one of the following: Right-click on the selection and select Format Cells. On the Protection tab, check the Locked check box and click OK.Īgain, locking cells has no effect until you protect the worksheet.Ĭell A1 and cell A2 are locked now. Right click, and then click Format Cells (or press CTRL + 1).Ħ. For example, select cell A1 and cell A2.ĥ.
On the Protection tab, uncheck the Locked check box and click OK.Ĥ. Excel provides methods for protecting Workbook, Chart, and Worksheet objects. To lock specific cells in Excel, first unlock all cells. Excel 2003 Programming: A Developers Notebook (Developers Notebook),2004. The password for the downloadable Excel file is "easy". Driving Lesson 7 - Worksheet & Cell Protection P Park and Read Worksheets can be protected with passwords so that no changes can be made to the locked cells. To unprotect a worksheet, right click on the worksheet tab and click Unprotect Sheet. If you record a macro to unprotect and another pacro to protect you will see what the syntax is and how it works. On the Protection tab, you can verify that all cells are locked by default.Īll cells are locked now. Use a macro and if the protection is password protected you will have to include the password in the macro. Right click, and then click Format Cells (or press CTRL + 1).ģ.
0 kommentar(er)
