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