Deactivate all the hyperlinks in an entire workbook?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SouthAfricanStan - 10 Nov 2006 07:14 GMT

How do I do this?

Reply to this Message

VBA Noob - 10 Nov 2006 09:12 GMT

Think this might work

Sub DelAllHyperlinks()

Dim WS_Count As Integer
Dim I As Integer

WS_Count = ActiveWorkbook.Worksheets.Count

For I = 1 To WS_Count

Sheets(I).Hyperlinks.Delete
Next I

End Sub

VBA Nob

> How do I do this?

Reply to this Message

Gord Dibben - 10 Nov 2006 21:38 GMT

Sub Delete_Hyperlinks()
Application.ScreenUpdating = False
Dim n As Single
For n = 1 To Sheets.Count
Sheets(n).UsedRange.Cells.Hyperlinks.Delete
Next n
Application.ScreenUpdating = True
End Sub

Gord Dibben MS Excel MVP

>How do I do this?

Reply to this Message

SouthAfricanStan - 12 Nov 2006 16:11 GMT

Thanks so far.
I'm a newby as far as this part of excel is concerned.
Please advise me (key by key) how to do this, or perhaps there are relevant
tutorials available on the internet?

> Sub Delete_Hyperlinks()
> Application.ScreenUpdating = False
[quoted text clipped - 8 lines]
>
>>How do I do this?

Reply to this Message

Dave Peterson - 12 Nov 2006 16:16 GMT

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

> Thanks so far.
> I'm a newby as far as this part of excel is concerned.
[quoted text clipped - 13 lines]
> >
> >>How do I do this?

Signature

Dave Peterson

Reply to this Message

Gord Dibben - 12 Nov 2006 17:11 GMT

If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + r to open Project Explorer.

Find your workbook/project and select it.

Right-click and Insert>Module. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run the macro by going to Tool>Macro>Macros.

You can also assign this macro to a button or a shortcut key combo.

Gord Dibben MS Excel MVP

>Thanks so far.
>I'm a newby as far as this part of excel is concerned.
[quoted text clipped - 13 lines]
>>
>>>How do I do this?

Gord Dibben MS Excel MVP

Reply to this Message

SouthAfricanStan - 12 Nov 2006 17:57 GMT

Thank You!

> If not familiar with VBA and macros, see David McRitchie's site for more
> on
[quoted text clipped - 41 lines]
>
> Gord Dibben MS Excel MVP

Reply to this Message