I love your approach and really thought that it would solve my problem.
I have a feeling I'm not going to like the answer, but I'm going to ask the question anyway, just in case.

When I paste, I answer No - I don't want to use Normal.
Turning off DisplayAlerts gets rid of the annoying prompt, but seems to answer with the default Yes - I do want to use Normal

So the question is, is there any way to modify this so that it doesn't use normal? I'm guessing any answer would have to involve SendKeys or something.

Thanks!