The information in this article applies to:
SUMMARYThe GET.CELL macro function with type number 15 returns TRUE or FALSE, depending on whether the selected cell has been hidden by selecting Cell Protection from the Format menu and checking the Hidden check box. This function does not test to see whether the cell has been hidden using the Row Height or Column Width commands in the Format menu. MORE INFORMATION
Formatting cell protection to hidden prevents a selected cell's
formula from being displayed or changed in the formula bar.
GET.CELL(15) will return TRUE if the cell protection is formatted as
hidden in this manner. GET.CELL(15) does NOT test for columns or rows
that have been hidden by choosing the Row Height or Column Width
command from the Format menu and choosing the Hide button. You can use
GET.CELL(16) and/or GET.CELL(17) to test for hidden rows or columns.
REFERENCES
Online Help, version 5.0 Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 4.0 5.0
Keywords : kbcode kbprg |
Last Reviewed: October 22, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |