I have a spreadsheet with multiple tabs for each manager and an archive tab. At the moment I have a script in place that will automatically remove the row from a managers tab and put into the archive. for Data protection no manager has access to the other managers tabs or the archive. Now this is where the issue is to deny access to the other tabs they are protected but this stops the script from running as its sending to a protected tab.
ANY ideas how I can get around this without giving them access.
The tabs are hidden and protected