CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-sheets-api
Bubz
Bubz

Reputation: 180

How do I hide a single sheet, in google spreadsheets, using google-spreadsheet-api?

I wish to be able to hide certain sheets in my Google spreadsheet programmatically. So when a shared user logs into the spreadsheet, certain data ranges, sheets maybe hidden from their view. This way I can make all, some or no spreadsheet data visible according to the viewers email address.

I have no problem doing this with sheet protection using SpreadsheetApp classes and methods, and protecting certain sheets based on the viewers email address. But cant seem to find any classes or methods that support sheet hiding methods or properties

Upvotes: 1

Views: 4122

Answers (1)

AdamL
AdamL

Reputation: 24609

There is an open enhancement request for hiding/showing sheets; you might like to star it to be kept updated.

Upvotes: 2

Related Questions