How can I open a specific worksheet using VBA code on a command button macro?

[liamdocherty]

Hi,


I was wondering how can I open a specific worksheet using VBA code on a command button macro? When then user accesses my "Welcome Sheet" worksheet and clicks on the command button "Students" this should bring them to the "Students" worksheet.


I tried the following code but I got an invalid syntax error message as you can see in this [image.](https://ibb.co/sWGKqRp) Furthermore, some of the code turned to a red code and also one line had a yellow background effect as you can see in this [image.](https://imgur.com/a/JXnMnRf)


Code:


Private Sub CommandButton_2Click()
Sheets("Students").Activate
End Sub




Incase you wanted to check the command button macro is called the same name as written in the code my excel worksheet is linked below. However, I did check and to me it's all correct.




[Video](https://streamable.com/s/984qm/xmsmqv) of me showing I have a worksheet called "Students" and I have correctly set up the command button correctly.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ba-code-command-button-macro.html#post5200640

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).