Back button in excel web apps

Question

I have an excel document on skydrive that I share with my coworkers and it has many sheets. I want to put a back button on it that would take the user to the previous sheet, from where they came to the now active sheet. I know how to do that with a VB script in excel but that solution doesn't work on excel web app. Can someone please help?

Answer 1

You can use Excel Services JavaScript API to achieve this.

http://msdn.microsoft.com/en-us/library/hh315812(v=office.14).aspx

Above link show you how to create a basic JavaScript snippet to render a workbook using JavaScript API.

Below links shows you how to activate a sheet.

http://msdn.microsoft.com/en-us/library/ee660110(v=office.14).aspx

Do you need to save the changes made by user? JavaScript API does allows you to open workbook in View mode and not edit mode.