Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to click on one cell of a column in a Straight Table (CH83) of my sheet 1 and, automatically, going to sheet 2.
How I can do this?
Can you help me, please
Best Regards
Nancy
See attached.
Thanks Rebecca!!!
1 – To set the sheet condition go to sheet properties > general you will see a radio button under Show Sheet
Click Conditional and add your equation in there
I use =if(GetSelectedCount(FIELD)=1,1,0)
2 – To set the button condition go to button properties and in enable condition add the same equation – this will mean the button stay there but is greyed out and not useable till a selection is made
It is possible to make the button not there but that involves variables which will take a little longer to put together an example and instructions so try this and if it doesn’t suit let me know.
Thanks Bella,
Bella:
I did it!
Thanks a lot!
Thank you so much Rebecca, you application made may day
Great