Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • 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