The VBA script in this section will help you to solve this problem easily.ġ. If you don’t want to protect the worksheet to make cell as read only. Here you can use the Protect Worksheet and Unprotect Worksheet utilities of Kutools for Excel to quickly protect or unprotect multiple worksheets or all workrksheets in current workbook with password at the same time.ĭownload and try it now! ( 30-day free trail) Microsoft Excel allows you to protect one worksheet with password at a time. Protect multiple/all worksheets with password at the same time in current workbook: When you try to edit these specific cells inside the range, you will get a prompt box as below screenshot shown. Now cells in the locked range are read-only now. Specify and confirm your password to protect the worksheet as below screenshot shown. Go ahead to click Review > Protect Sheet. Press the Ctrl + 1 keys simultaneously to open the Format Cells dialog box, check the Locked box under the Protection tab and click the OK button.Ĥ. Now select the cells you want to make them as read only (here I select cells of range A1:C18). In the dialog box, uncheck the Locked box under the Protection tab, and then click the OK button. Press the Ctrl + 1 keys simultaneously to open the Format Cells dialog box. Click the button on the top left corner of current worksheet to select the whole cells.Ģ. You can only lock the cells which you want to make them read-only, and then protect this worksheet to achieve it. Make cell as read only by VBA code without protecting worksheet Make cell as read only by protecting worksheet This article provides two methods to help you make specified cells as read only, so that others cannot edit these cells except for reading. In many cases, you may need to prevent others from editing some specified cells in your worksheet.
0 kommentar(er)
