3 Replies Latest reply: Dec 9, 2013 2:17 PM by Jaydeep Chavda RSS

    user level security and tab level selection issue

      on my multi tab dashboard I have tab level condition for select filter like below.


      Sub selectsheet


      set q = ActiveDocument

      set s = q.Sheets("Co-Promotion Deal information")

      if s.IsActive  then



      end if


      it works fine.


      but now i need to hide sheets based on qlikview user like below.



      =OSUser()<> 'user'



      but doing so is braking my vb code above becasue when other tabs are selected error on below.



      >set s = q.Sheets("Co-Promotion Deal information")





      how to make both work?