can I hide/show labels(2 worksheet act as Labels) which acts as URL. Can I hide/replace worksheet like Active/Non Active.
2 individual worksheets has 2 labels. Labelname doesn't matter. Say in this scenario
Hide (1st work sheet show)
Show (2nd work sheet show)
The end user shouldn't feel any hint,what happen behind when end user does the selection from Filter
In detail I have Dashboard level Filter when Drop down box selects 'ALL' records. It should just show same label name but when it selects records it should show another label
Please attach a sample workbook if possible.
Not so sure about your requirement, but it somewhat sounds like swiching between views.
A link for your referece.