Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
suppose if i got two sheets,sheet1,sheet2
on sheet1 i got 26 text box each text box as activate to sheet2 trigger on
so my requirement is when i open the application only sheet1 as to be visible ,later if i click on any of the text box (26),then sheet2 should appear ,and after pressing clear all button it should disappear....
so literally i need hide and show sheet tab
define a button with Action external "set variable" (e.g. vsheet1 and Expression
"if (vsheet=1,0,1)
now define in sheet properties condittional (vsheet1=1= adn you can toggle with your button (donot plaqce the button on the sheet you want to hide!)
abd then give trigger to last text box or sheet on leave trigger so it will gives u
You can use conditional hide/show option on the General tab of sheet properties
Hi,
PFA,
Thanks,
AS
1) Create one variable on front end as vShow.
2) On sheet 1 go to properties of text object -> Action -> add -> External -> Set variable -> vShow ->value=1.
Like wise you set the variable value for each 26 text object. So for 26th text object vShow value should be 26
3) Go to Setting-> Document Properties-> Triggers-> OnOpen -> add External -> Set Variable -> vShow ->value=0
Now go to sheet 2 properties ->general tab ->conditional ->Put below condition
=match('$(vShow)','1','2','3',......'26')