#How to create navigation tabs in word full
Full feature free trial 30-day, no credit card required! Get It Nowġ. Kutools for Excel- Includes more than 300 handy tools for Excel. If you want to batch create multiple buttons to open all worksheets, you should try Kutools for Excel’s Create List of Sheet Names utility. Click the button, it will skip to the specified worksheet immediately.Ĭreate buttons to open all sheets with Kutools for Excelīoth above methods can only create one button to open one sheet. Now you will get a form control button as below screen shot shown.
Save the code, and close the Microsoft Visual Basic for Application window. Note: In the code, please change the Sheet1 to required sheet name based on your needs.Ĥ. See screen shot:Ĭode: Go to certain worksheet in Excel ThisWorkbook.Sheets("Sheet1").Activate Now the Microsoft Visual Basic for Applications dialog box opens, please paste following code between sub and End sub. In the dialog box, type a name for the macro into the Macro name box, and then click the New button.ģ. Draw a button, then an Assign Macro dialog box comes out.
#How to create navigation tabs in word how to
Note: By default the Developer tab does not display in Ribbon, click to know how to show/display developer tab in Excel Ribbon.Ģ. Click the Developer > Insert > Button in Form Controls section. This method will walk you through creating a form control button to open certain worksheet.