I would like to write some VBA code which fires when a task is pasted. The reason is that users quite often create new tasks by copying existing ones, forgetting that these already contain values, e.g. baselines, notes, etc.
The code should fire when a task is pasted and prompt the user if they want to remove the “hidden” information from the tasks.
This means that the code should fire:
– when a user has copied one or several tasks from the actual or a different schedule, and pastes them into the actual schedule
It should however not fire when:
– a new empty line is created
– a task is just moved (drag and drop or cut and paste)