title: How to run script when cell is change
body: <p>I have this script in Google Sheets, i want it to run when cell A6 changes to "Accept" I need to do this because Google Sheets dont show drawings when using tablet.</p>
  
  <p>I found out its starts with <code>function onOpen(e)</code></p>
  
  <p>Someone knows how to do this?</p>
  
  <p>My code :</p>
  
  <pre><code>function Melding() {
    var email = Session.getActiveUser().getEmail();
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sheet = ss.getActiveSheet();
    var cell = ss.getActiveCell().getA1Notation();
    var row = sheet.getActiveRange().getRow();
    var cellvalue = ss.getActiveCell().getValue().toString();
    var recipients = sheet.getRange(7, 7).getValue();
    var message = '';
    }
    var subject = 'Update : '+sheet.getRange(4, 2).getValue();
    var body = 'text ' + sheet.getRange(4, 2).getValue() + ' text. ' + '\n' + '\nFølg link for å se endringer : ' + ss.getUrl() + '\n' + '\n' + 'text : ' + '\n' + '" ' + sheet.getRange(6, 7).getValue() + ' " ' + '\n ' + '\n (Google) ' + '\n' + '\n - VS ' + message +'';
    MailApp.sendEmail(recipients, subject, body);
      var sheet = SpreadsheetApp.getActive().getSheetByName('Sheet1');
    sheet.getRange('G6').setValue('No MSG');
    Browser.msgBox('Takk for det' , 'MSG sent to : '+sheet.getRange(7, 7).getValue()+ '\n' + '  - (From : '+email+')', Browser.Buttons.OK);
  </code></pre>