Google-sheets – Toggle named range window with a button

google sheetsgoogle-apps-scriptgoogle-sheets-named-ranges

I would like to know if it would be possible to toggle the different features in sheets with a script.

What I am trying to do is to basically create a button that will show the Named Ranges side panel without having to go Data > Named Ranges.

How can I script this?

Best Answer

Per @Rubén's comment, it doesn't appear possible to call up interface items in the way you describe.

However, you can make use of the native keyboard shortcuts.

To get to Named Ranges on a PC:

  1. In Google Chrome: Alt + d. Other browsers: Alt + Shift + d
  2. Press n.

On a Mac:

  1. Ctrl + Option + d
  2. Press n.
Related Topic