![]() ![]() If there are many worksheets in the workbook, you will certainly spend a lot of time on inserting hyperlinks.Ģ. You can also change the VBA codes to fulfill other requirements.ġ. Through VBA procedures, you can finish this task with just one click.Ģ. If you have no knowledge about VBA, you can use this method.ġ. Every Excel users can use this method easily.Ģ. And we will compare the difference of the two methods in the table below. In our previous article How to Create a Catalog in Your Excel via Hyperlinks, we add the catalog manually. From this method, you can easily create a catalog in a quick time. And all the sheet names are listed in the worksheet with the corresponding hyperlinks. There is a new worksheet named “Menu” in the workbook. Now come back to the interface of worksheet.In addition, you can also press the button “F5” on the key board. Now press the button “Run Sub” in the toolbar. ![]() If you need to input the catalog in different range, you can also modify it according to your need. Besides, we will input the list in the first column in the new worksheet. If there is already a worksheet named “Menu”, you can either change the VBA code or change the name of the existing worksheet name. In this code, we insert a new worksheet named “Menu” in the beginning. Worksheets(“Menu”).Range(“A” & a) = Sheets(a).NameĪ Anchor:=Worksheets(“Menu”).Range(“A” & a), _ Worksheets(“Menu”).Range(“A1”).Value = “Menu”įor a = 2 To Now copy the following VBA codes into the new module:.Therefore, you have inserted a new module into the project. In the sub menu, choose the option “Module”.And then move your cursor on the option “Insert”.Actually, you can also press the shortcut key “Alt +F11” on the keyboard to open the editor quickly. Thus, you have opened the Visual Basic Editor. And then click the button “Visual Basic” in the toolbar.Now click the tab “Developer” in the ribbon.In the “Excel Options” window, check the option “Developer” in the “Main Tabs” area.And then click the button “Customize the Ribbon” in the menu.Right click one of the tabs in the ribbon.In the image below, there are many worksheets in the workbook.Īnd now you can create a catalog in this workbook. Therefore, here we have a new method to quickly create such a catalog. But adding hyperlinks one by one manually can be time-consuming. Creating a catalog for a workbook with many worksheets can be very useful. 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. Here we have a quick method to create a catalog in an Excel worksheet. Creating a catalog for a workbook with many worksheets is necessary. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |