Random Hyperlink problem

Pauljj

Well-known Member
Joined
Mar 28, 2004
Messages
2,046
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 ?????
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

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,046
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,046
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,046
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 ?
 

Forum statistics

Threads
1,172,227
Messages
5,879,807
Members
433,457
Latest member
destinatus

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