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

    User selected default Sheet/tab

    Steve Taschereau

      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?

       

      Thanks,

      Steve