Category: User Interface

Google Spreadsheets User Interface

Bulk Hide, Show, Delete & Copy Multiple Sheets in Google Spreadsheets

Update: This script now allows you to copy multiple sheets within one spreadsheet to either the same spreadsheet or a different one. If you want to copy the sheet to the same spreadsheet just input your current spreadsheet’s id when prompted. The spreadsheet id can be found in the Spreadsheet’s URL eg: If you are looking […]

User Interface

Google Spreadsheet Button to Run Scripts in 4 Steps

If you come from Excel, you might have seen some fancy spreadsheets with clickable buttons that trigger VBA macros. Luckily, Google Spreadsheets and Google Apps Script offer the same functionality. If you are just starting out with Google Apps Script, checkout out this Google Apps Script macro tutorial for a beginners guide. This tutorial will […]

User Interface

Google Apps Script Custom Menus

  It is fitting that my first post on this site is about custom menus with Google Apps Script, because, often, custom menus are your users’ first touch with your custom functionality. Your users will be surprised the first time they see the custom menu on their Google App UI. And they will be delighted when […]