Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Quick question in my application qvw file contains 16 sheets but I would like to show 4 sheets including objects how do I hide the sheets in my app? Can anyone throw some light on this
Thanks,
V
You can use the Show Sheet option on the General tab of the properties window of the sheet to show or hide a sheet. If you select the Conditional option you can enter an expression that returns a numeric value. To hide the sheet make the expression return 0. To show the sheet make the expression return any number that isn't 0. So if you want to permanently hide them simply use 0 as the conditional expression.
Hi Verendra, you can go to sheet properties>general>conditional=0 Do this for each sheet you want to hide.
Hope it helps.
Cheers,
Andrés
You can hide the sheet by Sheer Properties --> General --> Show Sheet --> Conditional --> write your conditions
Based on conditions & selections, you can show only 4 sheets at a given time.
Dear Verendra,
Kindly find attached App, I hope you are looking for that one solution.
Kind regards,
Ishfaque Ahmed
Folks,
Thank you all for taking your time.
Thanks a lot. It works.
Kind regards,
Verendra
Hi Ishfaque Ahmed,
Thank you for your examples it's really helpful the which you sent me. Spot on...
Kind regards,
Verendra.
Hi Gysbert,
Thanks a lot.It works
Kind regards,
Verendra