Microsoft KB Archive/120116

{|
 * width="100%"|

XL5: Previous Property Doesn't Work if Sheet Protected

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, version 5.0

-

SYMPTOMS
In Microsoft Excel, when you use the Previous property in a Visual Basic procedure to select an unlocked cell previous to the selected cell on a protected worksheet, the incorrect cell is selected.

CAUSE
This behavior only occurs on a protected sheet that contains unlocked cells. When you use the Previous property in this case, the next unlocked cell is actually selected. For example, if cells A1:C1 are unlocked on a protected worksheet, and you select cell B1, if you use the Previous property to select the previous unlocked cell, cell C1 is selected instead of cell A1.

The Previous property behaves exactly the same as the Next property when used with unlocked cells on a protected worksheet.

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel version 5.0c for Windows.