function shareActive() {
var ss = SpreadsheetApp.getActive();
var sheet = ss.getActiveSheet();
var newSheet = SpreadsheetApp.create("New Sheet");
var id = newSheet.getId();
var open = SpreadsheetApp.openById(id);
var copy = sheet.copyTo(open);
var ui = SpreadsheetApp.getUi();
var user = ui.prompt('Enter user email address', ui.ButtonSet.OK_CANCEL);
if (
user.getSelectedButton() == ui.Button.OK
) {
var email = user.getResponseText()
}
DriveApp.getFileById(id).addEditor(email);
}
function onOpen(e) {
SpreadsheetApp.getUi()
.createMenu("Share Sheet")
.addItem('Active Sheet', 'shareActive')
.addToUi();
}