Rhys has attended:
Excel VBA Advanced course
Auto-Hyperlinking
Hello
I am currently having some issues with the fact that Excel auto-hyperlinks when entering the string "ftp" in a cell.
I am able to sort this outside of VBA by going to File >> Options >> Proofing >> AutoCorrect Options and unchecking the "Internet and network paths with hyperlinks" selection.
But since colleagues will also be using this document I would like this to be done automatically when opening the Workbook. I have tried recording a macro while doing this but it proved unhelpful.
Does anyone know of any vb code to do this?
Thanks
Rhys
RE: Auto-Hyperlinking
Hi Rhys
As you say you can turn off the Auto hyperlink option manually for Excel with File, Options, Proofing, AutoCorrect Options.
You will need to write a VBA script to do this automatically when a workbook opens. See the link
http://www.techrepublic.com/article/prevent-the-automatic-creation-of-hyperlinks-in-microsoft-excel/ #
The article also suggests an alternative is to include the label prefix ' to prevent automatically formatting as a hyperlink.
Regards
Doug Dunn
Best STL
