XL5: Previous Property Doesn't Work if Sheet Protected |
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 query words:
Keywords :
Version : 5.00
Platform : WINDOWS
Issue type :
Technology :
|
Last Reviewed: September 14, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |