2

I used the script underneath in Google Spreadsheet and added an image that when clicked upon runs the GOTOSHEETONE function to navigate to sheet: SHEETONE.

So far so good. However, when I publish my document this function is not executed anymore. A link to a Google form, which is also in my document, does work when published. Is there a way to make this function also run in published document mode?

function showSheetByName(Name) {
   var ss = SpreadsheetApp.getActiveSpreadsheet();
   var sheet = ss.getSheetByName(Name);
   SpreadsheetApp.setActiveSheet(sheet);
}

function GOTOSHEETONE() {
   showSheetByName("SHEETONE");
}
1
  • 1
    Working with images is tricky. The image needs to be publicly available and (I believe) outside your domain. Why not create an UI with a button (and add image to button)? Aug 26, 2014 at 10:43

1 Answer 1

1

Is there a way to make this function also run in published document mode?

The short answer is, unfortunately, no. The published version of a spreadsheet has many functional limitations, and this is one of them.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.