I have a strange request where the trigger on a object should be set with a macro. The issue is, at times we loose the triggers, so as an exception handling we are wanting to write a macro which will set the trigger as soon as a sheet is activated. How can we achieve this??
Its really difficult to reproduce such issues and so don't really have an explanation as to how it had happened. So for handling such incidents in future, I was thinking to create a macro which will check if the triggers are in place and if they are missing, the macro should set the trigger.
I know its kind of being very optimistic but trying to find an answer. Let me know if you could suggest any other solution.
The easiest way might be to make all your requirements with macro-code. Alternatives could be to upgrade the system to the last release and/or to rebuild the complete application (sometimes a qvw get corrupted - firstly with a more or less copy + paste approach and if it don't work with more efforts for each object).