How to Activate Multiple Highlighted Links in Excel

Microsoft Excel allows you to create shortcuts to files and websites through the hyperlink function. The F2 shortcut allows you to activate individual links. If you want to activate multiple highlighted links, you must create and then run a macro. A macro is a set of commands that performs the same action on a set of selected cells.

Instructions

1. Launch Excel and open the desired Workbook with the highlighted links.

2. Press the “CTRL” and “F11” keys to open the Visual Basic Editor.

3. Click “Insert” and then select “Module.” A new module window appears.

4. Paste the following code into the module:

   Sub editcell()
   application.screenupdating = false
   For i = 1 To 10
   SendKeys "{F2}"
   SendKeys "~"
   Next i
   application.screenupdating = true
   End Sub

5. Place your mouse at the beginning of the column containing the highlighted links.

6. Click “Tools” and then “Macros” from the top menu.

7. Click the macro you created in step 4 from the list of available macros.

8. Click “Run.” All highlighted links in the column are activated.