How can I optimize this Macro execute faster for google sheets-CodePudding

https://docs.google.com/spreadsheets/d/1jnRXbKsqzF99AcG-M5JJIipBQ-sjlSuzEQAeXZ6fq0I/edit?usp=sharing

I have an inventory system where the user uses SHIFT CTRL ALT 1 to generate the format and drop down menus for a receiving log.

I know next to nothing about coding, please explain like i'm dumb.

I was hoping that moving the order of some commands around or applying multiple colors and drop downs at the same time would shorten run time but i don't know what i'm doing.

CodePudding user response：

We need to see the macro but in google Sheets you can add a menu button at the top that users can click to run any of your macros.

function initMenu(){

  var ui = SpreadsheetApp.getUi();
  var menu = ui.createMenu("My Macros");
  menu.addItem("New Packing Slip", macroOne);
  menu.addItem("Slip", macroTwo);
  menu.addItem("Add Blank Row", macroThree);
  menu.addToUi();

}