I need an advice on how to trigger a macro when pressing the update button in external links window (in excel).

As far as I know, there is no such event which would do the job.

I know that there is a possibility to create a custom event, however I have no experience with programming such complex classes, and in addition I'm not even sure if this is possible.

Any suggestions would be highly appreciated.