Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
I having multiple sheets , in each sheet it is having clear buttons ok
In the first sheet , i have used the activation of sheet object ,then it going fine.
when i am clicking the clear buttons, it should clear the current sheet and the sheet should be the current sheet , it should not go to another sheet,(i.e it should clear all the selection in the sheet and it should not go to another Sheet)
I am trying this to do , but when i was trying to clearing the sheet it is clearing the selection and it is going to another page ,
So i want to restrict that , it should not go to another page.
Can you please suggest on this
Check the sheet and document triggers on the Triggers tab of the sheet and document properties windows and make sure there are no actions assigned to the triggers that navigate to another sheet.
Much less likely, but I have an application where one of the sheets is conditionally shown based on a selected value. So if you happen to be on that sheet, and hit clear, then you'll be switched to a different sheet, even though there's no trigger.