Disabling Hyperlink for specific Worksheet Excel 2007

[I heart Excel]

I am trying to turn off automatic Hyperlink formatting.

I know how to do it for each individual PC, but I require it for a particular document.

I have entered a Macro -
Sub ZapHyperlinks()
Cells.Hyperlinks.Delete
End Sub

But this means the end user filling out the form, has to ensure they select CTRL+z to run it. Is there anyway it can be done automatically for the document?

Thanks

 

[Andrew Poulsom]

To disable automatic hyperlinks you can use:

Application.AutoFormatAsYouTypeReplaceHyperlinks = False

You could put it in the Worksheet_Open event procedure and re-enable it in the Workbook_BeforeClose event procedure.

 

[I heart Excel]

Thank you, worked perfectly