Random Hyperlink problem

[Pauljj]

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

 

[Richard Schollar]

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 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]

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]

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]

That is strange then. Was the macro you used something like:

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]

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 ?