Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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);

function GOTOSHEETONE() {
share|improve this question
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)? – Jacob Jan Tuinstra Aug 26 '14 at 10:43

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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