Posts Tagged 'insert module'

How to Find Invisible Hyperlinks in Your Excel Worksheet via VBA

Invisible hyperlinks will sometimes cause trouble to you. And in this article, we will use VBA to find invisible hyperlinks in your Excel worksheet. In this image below, you can see that all the cells have the same format. But there exist some invisible hyperlinks among those cells. When you need to select a cell, you will certainly use your mouse and click it. But if the cell contains an invisible hyperlink, the computer will immediately launch the browser and open the hyperlink. This is...

Read more »

How to Quickly Create a Catalog for Your Excel Workbook via VBA

Creating a catalog for a workbook with many worksheets is necessary. Here we have a quick method to create a catalog in an Excel worksheet. In our previous article How to Create a Catalog in Your Excel via Hyperlinks, we have talked about creating a catalog by inserting hyperlinks in to a worksheet. Creating a catalog for a workbook with many worksheets can be very useful. But adding hyperlinks one by one manually can be time-consuming. Therefore, here we have a new method to quickly create...

Read more »