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
------------------------------------------------------------------------
|