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.