Originally Posted by BobBridges

Wait, what didn't work? You mean that after you copied the email addresses back to the original worksheet, they turned back into hyperlinks? (You gotta be specific, Tom.)

Yeah that's exactly what I meant! Sorry I wasn't more specific! In fact, it's not quite that simple. As near as I can tell, once I copied the email addresses back into the original, SOME of them turned back into hyperlinks but not all of them! That's bizarre!

If that's what you meant, then maybe I should have explained that you can turn off Excel's eagerness to create hyperlinks in the Options. Let's see, here... Ah, here it is: File, Options, Proofing, AutoCorrect Options, go to the AutoFormat As You Type tab, uncheck "Internet and network paths with hyperlinks".

Thanks for this suggestion. I know how to check this and I will. I think this might be a solution. I knew they made addresses hyperlinks by default but I had not gotten around myself to checking to see if I could turn that off! I will.

And remember, that link I pointed out said that the workbook might be protected or shared, if that's any help.