setSheetState

sets the visibility of a sheet

void setSheetState(string name,string state);
namestringa name of a sheet
statestringthe applied state

Example

$$("ssheet").setSheetState("Sheet2", "visible");

Details

Possible options for the state parameter are:

  • "visible" - to make a sheet visible;
  • "hidden" - to hide a sheet. It can be made visible on UI or by calling setSheetState() with the "visible" parameter.
  • "veryHidden" - to hide a sheet and disable the opportunity to make it visible on UI. The only way to make it visible again is to call setSheetState() with the "visible" parameter.
Back to top
Join Our Forum
We've retired comments here. Visit our forum for faster technical support, connect with other developers, and share your feedback there.