PDA

View Full Version : Solved: Hyperlinks need to go



Tenspeed39355
03-23-2006, 05:07 PM
Hi guys I have a ss that has a lot of data in it. 361 rows.
For some reason the ss has developed hyperlinks all over the ss. It is the same hyperlink. It sends the ss to ETFConnect.com. I have tried putting the 1 in a blank cell and then copy and hold down the Ctrl key and do a
paste special mult. That just messes up any data in the ss. Do you have a way to get rid of the hyperlink? If I open a new ss and copy the data from the ss that has the hyperlinks in it.The hyperlinks follow. If I send the ss to a friend the ss is real large. Any throughts on a fix? Thanks for your time.
Max

mdmackillop
03-23-2006, 05:32 PM
How about

ActiveSheet.Hyperlinks.Delete

Tenspeed39355
03-23-2006, 07:52 PM
Thanks that works super
Max

geekgirlau
03-23-2006, 08:23 PM
Max, don't forget to mark this thread as "Solved" using the "Thread Tools" option at the top of the screen.

lucas
03-23-2006, 08:40 PM
Hi Anne,
I don't think you can mark threads solved yet since the upgrade, they are still working on it. If Max comes back and confirms he is happy with the results of this thread you can edit the thread and mark it solved for him manually.

geekgirlau
03-23-2006, 09:19 PM
I haven't tried that for a while - was hoping it had been resolved but I'm sure they're working on it :work:

mdmackillop
03-24-2006, 04:00 PM
Hi GG
Not resolved yet. I'll take the response as +ve though
Regards
MD

Tenspeed39355
03-24-2006, 06:16 PM
Thread tools still does not work
Max