| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
XL3SheetVisible
Revision as of 12:48, 29 April 2016 by Antonio.remedios (talk) (Created page with "Shows and hides the specified worksheet, or the worksheet the formula is in. ==Syntax== {{Code|XL3SheetVisible( Visible, [SheetName] )}} ==Parameters== {| class="wikitable"...")
Shows and hides the specified worksheet, or the worksheet the formula is in.
Contents
[hide]Syntax
XL3SheetVisible( Visible, [SheetName] )
Parameters
| Parameter | Description |
|---|---|
| Visible | 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" )
