Can you help me?
I woul like to display and hide a chart based on a click of a button. Using the set variable option is only allowing me to display the object, but I wonder if I can hide the object with the same button, can someone advise?
I happened to have a very recent example on this. This is certainly possible and not very difficult, and it's very similar to what Mayil suggests.
Hope that helps.
The example works in the above document. But when I use the same in my current application it doesn't.
What could be the issue. Is some thing related to document properties.
Hi i am using the same variable VshowHide. i was just wondering if the show Hide can actually Say something else in the button for instance Show Yearly or Show Summary as that is basically what the button does. switch between the reports.
=if(vShowHide='Show','Hide','Show') & ' Charts'
i did change the show ,, hide to yearly and summary the button still shows and hides the charts but the button doesn't update to yearly once the summary charts are hidden
thank you in advance
I know that this was a long time ago...
Document Properties -> Tab Security -> Uncheck "Show All Sheets and Objects".
I was getting same problem... Nothing happened when button was pressed. It works fine now!
Maybe this will help someone later...
Bruno, there is a useful short-cut key Alt+Shift+S that shows all objects regardless of their Show Condition. You can also get to this setting via the menu option you describe. If you have show all selected then variable show will not work.
Regarding showing and hiding objects I have uploaded a couple of example apps that may give some ideas as to what you can do with showing and hiding objects from a button click:
Hope they are of interest.
Hey Jorge, Could you tell me if I want to do the same with a value present in list. Example :
List has three values power, performance , response. By clicking power, another sKu list should open, so on. In the end all these values should direct to a button and by the click of the button a new object should open up. CAn it happen please help out.