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. 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. Good during open jump time 10:30 am to 8pm. Good for walk-in.This method will walk you through creating a form control button to open certain worksheet. May 10, 2017We love Mom’s all year long, but on Mother’s Day we want to honor them by giving them FREE jump time! Mom’s get free jump time with a paid child admission on Mother’s Day, May 14th. May 17, 2017We’ll be open on Memorial Day, Monday, May 29th, from noon to 6pm! It’s a good idea to reserve your jump time online before you arrive. May 22, 2017The weather is getting warm, school is almost out and we can’t wait to offer you more hours of jump time! Monday Closed for group events Tuesday Junior Jumpers 9am-10:15am Open jump 1pm-10pm Wednesday Junior Jumpers 9am-10:15am Open jump 1pm-10pm Thursday Junior. Jun 30, 2017We’ll be open from noon to 5pm on Tuesday, July 4th. Reserve your jump time by phone or purchase at the front desk. Not valid during Junior Jumpers or in Kids Zone. Good during open jump time Tuesday through Sunday. Jul 31, 2017August HOT DEAL! For just $10 get two hours of jump time and a fountain drink. Aug 7, 2017August HOT DEAL extended! Back by popular demand! We’re extending our August HOT DEAL through Sunday, August 13th! - For just $10 get two hours of jump time and a fountain.

Open jump file