Sheet Hide and Show

[Nagaraju_KCS]

Hi Community,

I have 2 sheets(Sheet1 and Sheet2) in that two buttons Button1 and Button2.in each sheet

when i am open my application  i want to show Sheet1, when am click Button2 i want to show Sheet2 and

when i am click Button1 i want to show Sheet1

[VishalWaghole]

Hi

PFA hope so that will help u.......

Thanks and Regards,

Vishal Waghole

[#3]

You can try this,

Create a button in each sheet. let it be button1 and button2.

Create a variable vShowSheet and set its value to 1. Now for sheet1 go to properties>>general>>conditional show. give expression =$(ShowSheet)=1. and for sheet2 set the property as  =$(ShowSheet)=2.

Now for button1 set action in external action>>set variable and in variable name give ShowSheet and in value, give expression as =if($(ShowSheet)=1,2,1). and for button2 in sheet 2 give variable name in external event as ShowSheet and value as =if($(ShowSheet)=2,1,2).

Hope this works.

[CELAMBARASAN]

check the attached.

I have just checked the hide tab row in document properties.