How to Stop Hyperlinks in Design Tables

1) Turn your VB Visual basic Toolbar on.

2) Simply record a macro and save it in your Personal workbook. Make a name like "Remove_Hyperlinks" You can start and stop it real quick.

3) Go to Run macro, pick the macro you just saved and click edit. Place the code below in there and save it.

Sub Remove_Hyperlinks()
'
' Remove_Hyperlinks Macro
' Macro recorded 8/18/2002 by YourName

Range("A1:IV65536").Select
Selection.Hyperlinks.Delete
Range("A1").Select

End Sub

4) Once back in excel Right click in that Toolbar area and go to Customize.

5) In Categories scroll down to Macros and click it.

6) (I like to use buttons) So I picked Custom button. Pick that and hold down LMB and drag that button to your desired position in a toolbar.

7) Once dropped the button will stay highlighted, then you must click "Modify Selection".

8) Rename your button to the name of the Marco. You can edit the buttons image or simply change to one they have already made.

9) At the very bottom it says "Assign Macro". Click that and pick your macro from the Personal Workbook.

You can always re-edit the button later if you wish. Just repeat the steps. Except instead of dragging the button simply pick it.

You have now assigned that macro for that button.

Note 1: You must have your personal workbook active, and not hidden before you start

Note 2: You must make this Button and Macro when Excel is running on its own. Don't try and make this, when you have a DT open.