Change Hyperlink to Plain Text
 

Column has data that I would like to displayed as plain text to users instead
of having a hyperlink associated with it.

I can do one cell at a time but how would I do an entire column?

Change Hyperlink to Plain Text
 

try
columns(1).hyperlinks.delete

--
Don Guillett
SalesAid Software

"Sam" wrote in message
...
Column has data that I would like to displayed as plain text to users
instead
of having a hyperlink associated with it.

I can do one cell at a time but how would I do an entire column?

Change Hyperlink to Plain Text
 

If you are not familar with working in VBA you can highlight the whole
column, Press Ctrl C to copy the contents. Then rightclick the first row and
click 'paste Special'. Select the 'Values Only' radio button and hit Okay.
That should eliminate all the hyperlinks and leave their text Values.

"Don Guillett" wrote:

try
columns(1).hyperlinks.delete

--
Don Guillett
SalesAid Software

"Sam" wrote in message
...
Column has data that I would like to displayed as plain text to users
instead
of having a hyperlink associated with it.

I can do one cell at a time but how would I do an entire column?