General discussion

Locked

Dleleting Hyperlinks

By jwandco ·
Can you tell me how to delete hyperlinks. I know how to delete a singel one but not all of them at once? I'm not sure how they got on my spreadsheet but I have over 7500 lines that somehow got hyperlinks on them and the hyperlink needs to be removed. I did copie and paste did this cause this? And why did it put links where they don't belong? Thanks Sandy And where do I go to get an answer? I've never done this before.
Thanks Again!!!! : )

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by BFilmFan In reply to Dleleting Hyperlinks

Is this Excel? If so, you're in luck as I know how to do this:

You will need to create a macro to delete the hyperlink addresses in your Excel sheet.

Open your Excel spreadsheet that you wish to remove the hyperlinks from. Press <ALT>-F11 to go to the Visual Basic editor. Create a new module. You can do this by selecting Module under the Insert menu.

Paste the following code into your new module:

Sub RemoveHyperlinks()

'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete

End Sub

Close the Visual Basic editor window by selecting "Close and Return to Microsoft Excel" under the File menu.

Now, go to the sheet that contains the hyperlinks that you wish to delete.

Under the Tools menu, select Macro > Macros. Highlight the macro called "RemoveHyperlinks" and click on the Run button.

If you need to remove hyperlinks from other sheets, just repeat the steps above.

Collapse -

by jwandco In reply to

Thank you so much I will do this and yes I am using excel.... it's a pain!

Collapse -

by jwandco In reply to Dleleting Hyperlinks

This question was closed by the author

Collapse -

by jwandco In reply to Dleleting Hyperlinks

Well I did what I was told but now I get an error that says compile error syntax.error does anyone know what that means???

Collapse -

by jwandco In reply to Dleleting Hyperlinks

BFilmFan answered for me last time and ty

Back to Windows Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums