maybe one of these macro does something on an activate or open event, so
the paste is cleared then.

Look at this possibility