Question

0

285

Views

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 answers

Answer question

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 Report

0

Answer question

Find remote jobs

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

285

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

2 answers

0

0

Find remote jobs

Andres GPT