200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I'm wanting to open my excel workbook to the sheet that is after another sheet.
This is the code for opening a specific sheet but I want it to open the sheet that is after "Project Codes"
Private Sub Workbook_Open()
Worksheets("Project Codes").Activate
End Sub
Hello RWSM,
I'm guessing that the worksheet after "Project Codes" changes or you would have simply inserted that sheet name in your code. You need to use the index number of "Project Codes". A sheet's index number refers to its placement in the workbook, the order across the bottom of the workbook. To open the worksheet after "Project Codes" use this:
Private Sub Workbook_Open()
Dim IndexNbrA As Long
IndexNbrA = Sheets("Project Codes").Index
Worksheets(IndexNbrA + 1).Activate
End SubIf this solves you problem, please mark my answer as Selected
Cheers :-)
Private Sub Workbook_Open()
Dim IndexNbrA As Long
On Error Resume Next
IndexNbrA = Sheets("Project Codes").Index
If IndexNbrA < Worksheets.Count Then Worksheets(IndexNbrA + 1).Activate
End Sub