SIMPLE SELECT OR CLEAR ALL MACRO OR ACTIONS DON'T WORK IN AJAX
I need to select certain fields when I enter a sheet, and clear those filters when I exit that sheet. Normally this was an easy duty with a simple triggered action but now it does not work. Neither the macro module does. Does anybody know why?
In other words Select nothing, Clear, Unlock actions DON’T work in AJAX
Re: SIMPLE SELECT OR CLEAR ALL MACRO OR ACTIONS DON'T WORK IN AJAX
We are in the process of 'converting' to AJAX and have experienced similar problems.
As AJAX does not support a number of macros we are now using triggers as much as possible. Those tasks you have described - selecting, clearing, locking and unlocking - can easily be done by adding actions to the On ActivateSheet or OnLeaveSheet triggers in Sheet properties.