Is there any way to automatically delete a cell when you change tab? For example when you change from Sheet1 to Sheet2 it automatically deletes A1 cell from Sheet1 tab.

CodePudding user response：

I believe your goal is as follows.

• From Is there any way to automatically delete a cell when you change tab? For example when you change from Sheet1 to Sheet2 it automatically deletes A1 cell from Sheet1 tab., I understood that you want to clear a cell "A1" of "Sheet1" when the sheet is changed from "Sheet1" to "Sheet2".

In this case, how about the following sample script? In this sample script, I modified

References:

• onSelectionChange
• Properties Service
• Related thread.
  • Is there a google spreadsheet trigger that fires after a tab is changed?