![]() 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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |