4 Replies Latest reply: Feb 25, 2013 4:39 AM by Selvakumar S RSS

    User selected default Sheet/tab

      I'd like to create a User Preferences sheet in my app where the user can select/set things like the default sheet that opens when the app is opened.


      So here's what I did to accomplish this (needless to say, it's not working):  In the script I created an inline table of sheet names and sheet IDs similar to:


      [Sheet List]:

      Load * inline [

      sheet_name, sheet_id

      Dashboard, dashboard

      Foo, foo_123

      Bar, bar_id




      I then created a User Preferences sheet with a list box that displays sheet_name.


      Next I defined  a variable under Variable Settings: vDefaultSheetID = %sheet_id


      Lastly I defined a document Open Action to  set active sheet = vDefaultSheetID.


      What am I doing wrong?