PDA

View Full Version : Go To Sheet



da_phat
08-10-2010, 08:19 PM
Hi,
Hope someone can help. Im creating a button for my excel. I want that button after clicking it will go to the specified name sheet. Could you help me. Thanks

Bob Phillips
08-11-2010, 12:04 AM
Specified where, how?

fourstar787
08-11-2010, 12:05 AM
Not sure whats wrong with just pressing the sheet tab - unless you have hundreds of sheets?
but here you go!


Sub select_sheet()
Dim shtname As String
shtname = InputBox("Please Enter the Sheet name you with to use!")
ActiveWorkbook.Sheets(shtname).Select
End Sub

Trebor76
08-11-2010, 06:10 PM
Or just right-click on the navigation keys (bottom left-hand coner of the workbook) and click on the desired tab (note the active tab is ticked).