Getting list of all sheets

[deepakqlikview_123]

Hi All,

Please find attached screenshot.

Can you please suggest he to get list of all sheets.

thanks,

[deepakqlikview_123]

Thanks,

How to hide main sheet1 after getting dropdown list for sheet in above screenshot

[its_anandrjs]

Hi,

You can use variables for hide the sheets Like in Go to sheet properties -> Show sheet -> Conditional -> type variable name here and change this variable value from 0 to 1 in front end by input box. 0 for hide 1 for unhide.

Hope this helps

Thanks & Regards

[jsingh71]

GO to Documents Setting and select Hide row.

[#5]

You mean you want to hide the tab names "Main" and "Sheet1"?

If so, then you can go to Settings--Document Properties--General tab and on the right hand side among many check box options, you will have one option as "Hide Tabrow". Check that and the tab lables will be hidden.

Hope this helps!

[Colin-Albert]

You can also use buttons or text boxes with actions that will naviaget users to a specific sheet or to the next / previous sheet.

[CELAMBARASAN]

Hi,

I didn't know for what purpose your requirement.

I have done a sample with the help of triggers, dynamic update.

Attached QVW.