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.
