Question

0

294

Visualizações

How to remove focus from an Apps Script image button (Google Sheets)

I have a couple of buttons automating workflow on a Google Sheet.

After the assigned script has run, the image/button keeps keyboard focus. It only loses focus by pressing the escape key.

I haven't been able to find a programatic way to remove focus so I can get busy on the keyboard right away. There is one 'workaround' on here that opens then closes a sidebar but this is anything but elegant AND requires unncessary user permissions.

Any ideas?

[edited to add: .activate() and .setActiveSelection(range) do NOT remove focus from the image]

about 4 years ago · Juan Pablo Isaza

2 Respostas

Responde à pergunta

0

.activate will fit your needs.

var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
sheet.getRange('A1').activate;

//Or this to go to the first empty cell in col A

var lastRow = sheet.getLastRow();
sheet.getRange(lastRow+1,1).activate;

about 4 years ago · Juan Pablo Isaza Relatório

0

Responde à pergunta

Encontrar trabalhos remotos

Accepted Answer · 2022-07-13T11:01:56.340Z

The answer to this question is: There is currently no functionality to do this as of September 2021.

0

294

How to remove focus from an Apps Script image button (Google Sheets)

2 Respostas

0

0

Encontrar trabalhos remotos

Andres GPT