XL3SheetVisible
Shows and hides the specified worksheet, or the worksheet the formula is in.
Contents
[hide]Syntax
XL3SheetVisible( Visible, [SheetName] )
Parameters
| Parameter | Description |
|---|---|
| Visible | Boolean value. If set to TRUE the worksheet is shown; if set to FALSE the worksheet is hidden |
| SheetName | The name of the worksheet to set the visibility for, or the formula's worksheet if unspecified |
Examples
Hides the current worksheet if the value in cell A3 is less than or equal to 10000.
=XL3SheetVisible( A3 > 10000 )
Hides the worksheet named Details if the value in cell A3 is less than or equal to 15000.
=XL3SheetVisible( A3 > 15000, "Details" )
