XL5: Previous Property Doesn't Work if Sheet Protected

• 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.

REFERENCES

For more information about the Previous Property, choose the Search button in the Visual Basic Reference and type:

    previous cell