4 Replies Latest reply on Dec 6, 2018 6:51 AM by krishna.amilineni.0

    Actions to hide and show at same time

    krishna.amilineni.0

      Hi All,

       

      I have a situation. Trying to solve this since sometime. But I was not able to solve it.

      I have 7 worksheets(A, 1,2,3,4,5,6).

      My requirement is:

      • When no selection is made in worksheet A, I should see worksheets 1,2,3 and 4,5,6 should be hidden.
      • When I make a selection on worksheet A, I should see worksheets 4,5, 6 and 1,2,3 should be hidden.

       

      I am able to achieve the first requirement which is (When no selection is made in worksheet A, I should see worksheets 1,2,3 and 4,5,6 should be hidden.)

      But I am not able to get my second requirement which is (When I make a selection on worksheet A, I should see worksheets 4,5, 6 and 1,2,3 should be hidden.)

       

      Can anybody please help me in this situation or guide me to place where I can find the solution.

      Any help is appreciated.

       

      Thanks & Regards

      Krishna