|
01-23-2014, 06:19 PM
|
|
Novice
|
|
Join Date: Jan 2014
Posts: 10
|
|
Quote:
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.
|
I got this suggestion from another helper also. I actually really thought that was the problem since (and again I failed to mention this in the OP) the file I inherited IS a shared file! I did check the properties and the protection attribute, but it is entirely unprotected. I have not checked how it gets made a "shared" file yet, so I don't know if that's the problem. But from what I know about the source of the file I am betting you're onto something here!
I really appreciate your help! This is a PITA to me, but frankly it's not a showstopper. I'll make it clear when you don't need to keep working on this for me, if you haven't already reached that point!
Thanks very much.
|