Random Hyperlink problem

Pauljj

Well-known Member
Joined
Mar 28, 2004
Messages
2,013
I have been asked many times to delete unwanted hyperlinks from a spreadsheet, which I have done. The problem is they keep re-appearing, they re-appear without text, just the link which can only be viewed by hovering your mouse across them. The main problem is there are thousands of them per workbook, so it is slowing down opening the workbook. Has anyone experienced this problem before, or have any suggestions ?????
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
They can't just be reappearing out of nowhere - something must be driving their appearance. Code in the workbook? Another user creating them, maybe?
 

Pauljj

Well-known Member
Joined
Mar 28, 2004
Messages
2,013
Well I agree on the first part, they can't just reappear on their own. I have checked the code on the workbook and this is the only code on the workbook

Private Sub workbook_activate()

Sheets.Select

End Sub


I would go as far to say it would be impossible for a user to be doing this manually as there are thousands across many many workbooks ?
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Are you sure then that when you deleted them, you did in actual fact delete the hyperlinks, or maybe just the text in the cells? Note I'm really not sure how this might happen. How did you delete them?
 

Pauljj

Well-known Member
Joined
Mar 28, 2004
Messages
2,013

ADVERTISEMENT

There is no text, just the hyperlink. I ran a macro to remove them, which did work, as I went back to check...all very strange ???????
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
That is strange then. Was the macro you used something like:

Code:
For Each ws in ThisWorkbook.Worksheets
   ws.Hyperlinks.Delete
Next ws

I can't think of any reason why this would result in what you are seeing though.

Very strange indeed!
 

Pauljj

Well-known Member
Joined
Mar 28, 2004
Messages
2,013
Hello Richard, I have used that code before, this code like others also removes or alters the formatting, is there a way that can be stopped ?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,402
Messages
5,601,475
Members
414,452
Latest member
Dannysamworth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top