Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hai
My Requriment is i want to hide a sheet
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
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