ID: Q120116
5.00 WINDOWS kbprg
The information in this article applies to:
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.
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.
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.
For more information about the Previous Property, choose the Search button in the Visual Basic Reference and type:
previous cell
Additional reference words: 5.00
Version : 5.00
Platform : WINDOWSLast Reviewed: September 14, 1996