setSheetState

sets the visibility of a sheet

name	string	a name of a sheet
state	string	the applied state

Example

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

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