如何創建一個帶有超鏈接的下拉列表到Excel中的每個工作表？

如何創建一個帶有超鏈接的下拉列表到Excel中的每個工作表？

也許您之前已經創建了一個下拉列表，但是您是否曾經創建過一個包含指向Excel中每個工作表的超鏈接的下拉列表，如下所示？

創建帶有工作表超鏈接的下拉列表

創建帶有超鏈接的工作表列表

使用工作表超鏈接創建一個下拉列表

只有VBA代碼可以處理Excel中的作業。

1。 點擊 開發商 > 插頁 > 組合框（ActiveX控件）

.

注意：如果功能區中未顯示開發人員選項卡，請單擊 文件 > 附加選項 > 自定義功能區，然后檢查 開發商

右框中的選項。 看截圖：

2.然后在任意位置繪制一個組合框。

3.右鍵單擊您剛才繪制的組合框的工作表，然后單擊 查看代碼

從上下文菜單。

4.將以下代碼復制并粘貼到空白腳本中，然后保存以返回到工作表。

VBA：使用工作表鏈接創建下拉列表

5. Click Developer > Design Mode to exit the design mode. Now all sheets have been listed in the drop-down list, and it will go to the sheet while you clicking at the sheet name. Create a list of sheets with hyperlinks If you just want to create a list of clickable sheet names as below screenshot shown, you can apply Kutools for Excel’s Create List of Sheet Names feature which can create a list of hyperlinks about sheet names or list of macro buttons about sheet names. Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. Free Downloadfree full-featured in 30 days After installing Kutools for Excel, please do as below:（Free Download Kutools for Excel Now!) 1. Click Kutools Plus > Worksheet > Create List of Sheet Names. 2. In the Create List of Sheet Names dialog, do as below: (1). Check Contains a list of hyperlinks< to create a list of clickable sheet names, or check Contains buttons and macros to create buttons which link to each sheet. (2). Give the new sheet which you will place the hyperlinks in a name. (3). Specify the location of the new sheet. (4). Specify the sheet links displayed as how many columns. 3. click Ok, now the clickable sheet names have been displayed in new sheet. Demo Best Office Productivity Tools Transform Hours into Minutes with Kutools for Excel! Ready to supercharge your Excel tasks? Harness the power of Kutools for Excel - your ultimate time-saving tool. Streamline intricate tasks and glide through your data like a pro. Experience Excel at lightning speed! Why You Need Kutools for Excel ??? Over 300 Powerful Features: Kutools is packed with more than 300 advanced features, simplifying your work in over 1500 scenarios. ?? Superior Data Processing: Merge cells, remove duplicates, and perform advanced data conversions – all without breaking a sweat! ?? Efficient Batch Operations: Why put in extra effort when you can work smart? Import, export, combine, and tweak data in bulk with ease. ?? Customizable Charts and Reports: Access a broad variety of additional charts and generate insightful reports that tell a story. ??? Powerful Navigation Pane: Gain an advantage with the robust Column Manager, Worksheet Manager, and Custom Favorites. ?? Seven Types of Drop-down Lists: Make data entry a breeze with drop-down lists of various features and types. ?? User-Friendly: A breeze for beginners and a powerful tool for experts. Download Now and Soar Through Time with Excel! Read More... Free Download... Purchase... Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project. Open and create multiple documents in new tabs of the same window, rather than in new windows. Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day! Read More... Free Download... Purchase...