To manage when your macros operate, you can assign them to certain functions within Excel, for example opening a workbook, changing a sheet, or clicking a button. This is finished in the VBA editor, in which you can publish occasion-handler strategies that result in your macros. In this particular dialog https://www.customguide.com/google-sheets/how-to-lock-cells-in-google-sheets