Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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");
}
share|improve this question
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)? –  Jacob Jan Tuinstra Aug 26 at 10:43

1 Answer 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.

share|improve this answer

Your Answer

 
discard

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.