Hi Slaycock;

Thanks again for your responses. I do appreciate it.

Yes that's right. I don't want to change the hyperlink text. But I think we're talking about two different things. There are actually three parts to a hyperlink, right? There's the hyperlink field, which is hidden by default. Then there's the text that displays when the field is hidden—the text that the user clicks on—which is called "display text". And finally there's the tip that displays when the user hovers.

I'm trying to prevent changes to the "display text". The other two parts are unchanged as long as I keep fields hidden when the macro is running.

What you describe is different from what I'm seeing. If I make any change to the "display text," the change is permanent. The link itself still works—the hidden field is unchanged—but the display text is changed and it stays changed, even after updating the application screen.

So... yeah, I'm stumped.

Best,
DG