我对此非常陌生，没有找到一个对我有意义的解决方案，当我试图在当前的谷歌工作表上运行这个功能时，我继续收到错误，“请先选择一个活动的工作表”，但是我已经在我的功能范围内找到了这个工作表，对吗？

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu("MAH MENU").addItem("TEST", "crawlOnEm").addToUi();
}


function crawlOnEm() {
  var ui = SpreadsheetApp.getUi();
  var activeSheet = SpreadsheetApp.getActiveSpreadsheet();
  var selection = activeSheet.getSelection().getCurrentCell();
  var row = selection.getRow();
  var column = selection.getColumn();
  var sheetWeCareAbout = activeSheet.getSheetByName("Week-by-week");
  var walkingRange = sheetWeCareAbout.getRange(row, 1);                           
  var walkingRow = row;

while(walkingRange.getBackground() !== "#efefef" && walkingRow >= 1) {
  walkingRange = sheetWeCareAbout.getRange(walkingRow, 1);
  walkingRow++;
}
  ui.alert("Date is: " + walkingRange.getValue());
}