Automatically click another button in another sheet when a button on the main sheet is clicked. How to do it ?
Hi,
Attached is a sample dashboard.
In the Main sheet there is a button, clicking on which takes us to the next sheet.
The next sheet has button and a text box conditonally hidden. The text box appears on click of the button.
What i'm trying to acheiving is that when the button on the "Main" sheet is clicked it has to go to the next sheet and automatically click the button present in it and enable the text box instead of the user having to click the button in 2nd sheet again. How can this be done.
