Shows and hides the specified worksheet, or the worksheet the formula is in.
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" )
