2 Replies Latest reply: Oct 3, 2012 9:35 AM by Mayil Vahanan Ramasamy RSS

    How to Hide Sheet


      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
            Mayil Vahanan Ramasamy



            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..




            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