EnableSelection Property May be Overridden

   ActiveSheet.EnableSelection = xlUnlockedCells
				

   Range("B5").Select
				

MORE INFORMATION

You can use the EnableSelection property of a worksheet to determine what, if any, cells on a worksheet may be selected by the user. EnableSelection has three possible values:

   Value              Definition
   ---------------------------------------------------------------------

   xlNoRestrictions   Any cell can be selected.
   xlNoSelection      No cells can be selected.
   xlUnlockedCells    If the worksheet is protected, only cells that are
                      unlocked can be selected.
				

You can unlock a cell or group of cells by following these steps:

1. Select the cell(s) to be unlocked.
2. On the Format menu, click Cells. Click the Protection tab.
3. Clear the Locked check box. Click OK.

If the worksheet is protected and you have set the EnableSelection property to xlUnlockedCells, you cannot select locked cells, either by clicking them with the mouse or by using the Go To dialog box.

However, you can select locked cells by using the Name box on the Formula bar. If you click the Name box, type in a cell reference (D5, for example) or a range reference (D5:E10, for example), and then press Enter, the indicated cell or range will be selected.

Because the cells are locked and the worksheet protected, they cannot be changed. You can still copy or fill from a locked cell into unlocked cells without receiving any error messages.