Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Hide Sheet

Hai

My Requriment is i  want to hide a sheet 

2 Replies
fdelacal
Specialist
Specialist

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

MayilVahanan

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.