Select a cell or a range of cells, and press Ctrl + 1 to open this menu and go to the Protection tab. Use the corresponding checkboxes to activate properties. The second method is doing this via VBA code. Every cell and range can be made Locked and FormulaHidden properties.

How do I lock cells in Excel 2003?

Locking Cells

  1. Select the cell(s) to be locked.
  2. From the Format menu, select Cells… The Format Cells dialog box appears.
  3. Select the Protection tab.
  4. Select Locked. There will be a check before it.
  5. Click OK.
  6. You must now protect the worksheet.

How do I permanently lock cells in Excel?

Lock cells to protect them

  1. Select the cells you want to lock.
  2. On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window.
  3. On the Protection tab, select the Locked check box, and then click OK to close the popup.

How do I protect cells in Excel without protecting the sheet VBA?

Betreff: Lock cell without protecting worksheet

  1. Start Excel.
  2. Switch to the “Check” tab and select “Remove sheet protection”.
  3. Select all cells by clicking in the top left corner of the table.
  4. In the “Start” tab, select “Format> Format cells> Protection” and uncheck “Locked”.

How do I lock cells in Excel 2000?

Click in a cell, right-click to get to the Format Options window, and check “Locked” on the Protection tab. Contiguous cells can be formatted in one step by highlighting the entire range and then locking.

How do I make an Excel cell read only in VBA?

How to make cell as read only in Excel?

  1. Make cell as read only by protecting worksheet.
  2. Press the Ctrl + 1 keys simultaneously to open the Format Cells dialog box.
  3. Now select the cells you want to make them as read only (here I select cells of range A1:C18).
  4. Go ahead to click Review > Protect Sheet.

How do you lock cells in Excel so they are not editable?

Lock Cells

  1. Select all cells.
  2. Right click, and then click Format Cells (or press CTRL + 1).
  3. On the Protection tab, you can verify that all cells are locked by default.
  4. Click OK or Cancel.
  5. Protect the sheet.