XL3SheetVisible

Shows and hides the specified worksheet, or the worksheet the formula is in.

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" )

See Also