Publish Google App Script Editor Add-On for Google Sheet

[Raj C]

Dear Friends,

Below is my question on StackOverflow... but no answer so far..

Can anyone help me pls.

I am new to Apps Script. I am trying to publish an editor add-on for my Google Sheet. I will create about 100 copies of this sheet and share with about 100 or so editors.

The sheet has app script attached, which has onEdit function which protects check-boxes in a column from being deleted. It actually replaces the checkbox with old value.

var ui = SpreadsheetApp.getUi();

function onEdit(e){

     var ss = e.source; var s = e.source.getActiveSheet();

     if (s.getName() == "Sheet5" || s.getName() == "Sheet6"){

          var cell = e.range; var col = e.range.getColumn(); var row = e.range.getRow();

          .............

          .............

     }

}

The sheet also has custom methods which copies data from Sheet1 to Sheet2 and Sheet3 to Sheet4. The Methods / Functions are run when user clicks on a button (drawing).

All the code is tested and working fine when the apps script is attached to the sheet.

I would like to protect the apps script so the editors cannot change any code.

So, I created a stand alone Apps Script file. Copy all code from the original apps script attached to google sheet. Created google cloud project. Changed the project number in standalone Apps Script. Completed OAuth Consent Screen. Enabled Sheet API and Apps Script API in could project.

Then I was able to published my stand alone app script as editor add-on for all users.

But i don't know how to use or install this add-on in my Google Sheet. I created Test deployment as "Installed and Enabled". When i click on Execute it opens attached google sheet but the add-on doesn't do anything.

I am trying this since last 7 days but no luck. I don't know what is wrong.

Please help.

Best Regards,

Raj