Posts Tagged 'insert module'

How to Make a Lucky Draw in an Excel Worksheet via VBA

In Excel worksheet, you can also make a lucky draw. In this writing piece, we are going to show you how to finish this task in Excel. A Lucky draw is very common in our daily life. For example, you need to give bonuses to employees in the end of a year. You would like to select some lucky employees randomly. Therefore, you can use the Excel file to make a lucky draw. Make a Lucky Draw In this part, we will introduce the methods in detail. Open the Excel file with all the information...

Read more »

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 »