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?

I tried the following code but it doesn't work.

Private Sub CommandButton_2Click()
Worksheets("Students").Activate

 

[My Aswer Is This]

Do you have a sheet named "Students" in the active Workbook?

If so this script should work.

 

[liamdocherty]

Yes,

Could you have a little look for me please obviously I've made a mistake somewhere. It would be greatly appreciated.

EDIT:
Link removed at OP's request

 

[My Aswer Is This]

I never click on links or open files.

Your script was very simple. I should not need to open a file to see what you want.

 

[liamdocherty]

Fair enough but the code don't work.

 

[Fluff]

Looks like the name of the sub is wrong, I suspect that it should be

Private Sub CommandButton[COLOR=#ff0000]2_[/COLOR]Click()
Worksheets("Students").Activate

 

[My Aswer Is This]

I suspect you have a lot more in your script then just this.

Show me your entire script?

 

[Fluff]

Judging by the image in your duplicate post, you have the wrong type of brackets around the sheet name.

 

[welshgasman]

Judging by the image in your duplicate post, you have the wrong type of brackets around the sheet name.

I was about to offer the same, looking at the dupe post.?