Resolved >>> prevent hyperlink from showing

[Josh_123456]

Is there anyway to turn off hyperlink. Everytime I put in an @ symbol in the cell and hit enter, it changes it to a hyperlink and changes the font and size. Is there anyway to turn this off or prevent this without having to click on the cell everytime and choose, remove hyperlink.


thanks

Josh

[davesexcel]

Is there anyway to turn off hyperlink. Everytime I put in an @ symbol in the cell and hit enter, it changes it to a hyperlink and changes the font and size. Is there anyway to turn this off or prevent this without having to click on the cell everytime and choose, remove hyperlink.


thanks

Josh

This code removes hyperlinks in a worksheet

Cells.Hyperlinks.Delete

Or

'@whatever

[Josh_123456]

thank you, worked perfect


Josh

[Ikaabod]

To avoid having to do this in the future you can change this by clicking: Tools --> AutoCorrect Options... --> AutoFormat as You Type --> Internet and network paths with hyperlinks (off).