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??
I think to create or change a trigger with macros won't be possible. But if you used a trigger to execute the macro then the macro could do these things what the triggered action would have be done.
But a trigger couldn't really be lost - are you sure the trigger isn't deleted by a human activity, directly by removing or removing / renaming from the sheet/field/variable or similar?
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).
