Just as the title says. is this possible?

I had a quick look at office scripts but I believe these need to be triggered (cannot run on change/ on edit as VBA or google appscripts can)

I think it just cannot be done but if anyone has a solution I would be very grateful.

Thanks
Joe