For those who have just learned Excel, it is a bit difficult to get started. For this reason, the editor below will bring you a tutorial on how to automatically add hyperlinks in batches using VBA in Excel. Friends in need should not miss it.

1. Change Excel's VBA macro security to the lowest value to facilitate running macro code. Add a [Button Control] anywhere in the Excel table

2. Change the button control name

3. Double-click the button control to open the code editing VBA window; delete all displayed code.

4. Copy all the contents of this step to the VBA window

5. Return to the Excel window and click the button to execute the instruction.

6. The program will prompt you to enter the specified parameters. You can refer to the prompts for input. As shown below: Enter step by step. If the input is wrong, the program will crash and the instruction will be executed again.

If there is a program error, [click] [End button] and then click the Batch Hyperlink button again to try again.

Above, I have shared with you the tutorial on how to automatically add hyperlinks in batches using VBA in Excel. Friends in need should hurry up and read this article.