2 Replies Latest reply: Oct 3, 2012 9:35 AM by mayilvahanan ramasamy RSS

    How to Hide Sheet

      Hai

      My Requriment is i  want to hide a sheet 

        • Re: How to Hide Sheet
          facundo de la cal

          setting - document properties check Hide Tarrow and you can do

          botton on top with action active sheet, and not active the sheet that you want to hide

          • Re: How to Hide Sheet
            mayilvahanan ramasamy

            HI

             

            Right click the sheet and choose properties

             

            In General tab -> Show sheet -> select the conditional and give 0 and click ok..

             

            Sheet is hide..To view -> setting - document properties -> sheets-> select the sheet and click properties and tick to show..

             

            or

             

            Set variable vhide = 0. and use button to set the variable value as 0/1 by using if(vhide=0,1,0) and use vhide in conditional option in sheet properties..to show or hide the sheet..

             

            Hope it helps