我已经在表格中录制了一个宏,我希望能够从手机中运行。我了解我需要为特定单元格创建一个触发器(OneDit(e((,以使Google表格在云中运行宏。我没有编码知识,只能出色。任何帮助都非常感谢
在A1中输入X以运行Macro1
function onEdit(e) {//Don't forget the e
var sh=e.range.getSheet();
var name=sh.getName();
if(e.range.getA1Notation()=='A1' && e.value.toLowerCase()=='x') {
e.range.setValue('');//this will reset the value so that it will be ready to accepts another lower case x immediately.
e.source.toast('Hello World.');//You can remove this. It just lets you know that it has run
macro1();
}
}