Excel URL's

  • Thread starter Thread starter Don Niall
  • Start date Start date
D

Don Niall

I'm reposting this message as the recommended action
didn't work, and I cannot reply to his post ...
==========================================================
Hi,

If I have an Excel s/s that contains multiple fields with
live URL links, is there a way to deactivate the link? I'm
working with such a s/s presently, and its frustrating as
I inadvertently trigger URL links constantly!!
 
Public Sub DeleteHyperlinks()
ActiveSheet.Hyperlinks.delete
End Sub
 
Don

Copy a blank cell. Then Paste/Special/Add. This undoes the hyperlink.

Andy.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deactivate URL links 6
Live URL links in excel 1
Link Protection Forms 1
pasting formulas 2
Looping PoewrPoint Show linked to Excel 2
Change how a slide is triggered 0
Shadows don't work right in Office 2007? 1
Change hyperlink throughout excel 1

Back
Top