View Single Post
  #1   Report Post  
RWN
 
Posts: n/a
Default Hyperlinks - Turning off (Removing)

xl2k

Excel insists on treating a share name (\\directoryname) in a cell as a hyperlink. I use
them extensively on templates to point my VBA routines to the directories to be used.
Each time I enter it in a cell I have to turn around and Remove the link.

I've looked at Tools-Options, thinking that there must be a switch I could throw, but to
no avail.

Not a big deal as I could skip the double backslash and add it in the macro, but I'd
rather have the whole name in the cell to prevent confusion for the users.


--
Regards;
Rob
------------------------------------------------------------------------