This content has been marked as final. Show 3 replies
on my multi tab dashboard I have tab level condition for select filter like below.
set q = ActiveDocument
set s = q.Sheets("Co-Promotion Deal information")
if s.IsActive then
it works fine.
but now i need to hide sheets based on qlikview user like below.
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?