I have a shared Google Spreadsheet between 4 people. All users are in the same domain using Google Apps.
All 4 can edit the spreadsheet but I'd like to prevent ONE person from viewing OR editing specific column(s). The columns cannot simply be 'hidden' from view by right-clicking on the column.
What I'd like is a Google Apps Script that can do the above, which I can re-use on different Google Spreadsheets. Or, if you have a better suggestion let me know.
PS. We MUST be able to use the script with Google Spreadsheet. Maybe your Excel expertise will help with my requirements, but we won't be switching over to Excel.
It would help if you tell me you fully understand the project requirements and not send me a generic introduction message. Thanks!