title: Stop Excel from Following Hyperlinks
body: <p>Is it possible to stop <em>following</em> hyperlinks in Excel? I am very open to using macros and other methods. I found the following types of "solutions" after hours of searching but they would not work:</p>
  
  <ol>
  <li>Disable all hyperlinks by using Selection.Hyperlinks.Delete</li>
  <li>Have Excel turn off automatic hyperlink-ing</li>
  <li>Have a dummy sheet with the hyperlinks that links to itself and use VBA for activation on follow</li>
  </ol>
  
  <p>These do not work since I don't own the worksheet. My job is to automate reports/actions/calculations of my coworkers using user formulas or subs. The owner of the worksheet have lots of links included in the file which they would wish to keep. I cannot just arbitrarily remove their links. But troubleshooting and programming for me is difficult since I sometimes (not often, I usually use keyboard to navigate, but sometimes) accidentally click a link and there'll be popups and all that junk. I also cannot create a dummy sheet, since the worksheet contains some 10,000 lines of data, I'm afraid it would inflate the file size. Any help would be appreciated! Thanks!</p>