Ive got a multi sheet, spreadsheet that i want to give out to clients so that they can write in their comment directly into my spreadsheet.
There is nothing i don't want them see in the spreadsheet, apart from in one sheet called 'control'. I cant just remove this sheet as it contained formulas that are referenced else were in the document.
Is there a way i can give them the link to the google spreadsheet, but lock the 'control' sheet from being viewed ?
I dont mind doing this either by using an internal google drive setting, or by using a custom js google drive script (as correct me if im wrong but google spreadsheets, wouldn't work if the js is turned off, so they cant easily disable the js and just access the sheet.)