Command button to navigate between excel sheets

Hi
I am new to this forum so I do not yet know its etiquette so please bear with me if I am breaking any rule.
Also I am very very new at VBAs and macros
I am trying to create a VBA using a command button to open a specific sheet.
Here is my code:

Private Sub CommandButton1_Click()
ThisWorkbook.Sheets("Sheet2").Select
End Sub

I keep on getting error messages such as "error 438", "error 9"...
Can someone please help and tell me what I am doing wrong.
Thanks in advance

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Unable to replicate the issue. I copied your code to a new workbook. Made sure that there were at least two sheets in the book. Added a button. It works for me. Suggest you upload your workbook for analysis.

Hello Marieme,

According to your sample Workbook your Code should actually read:

Private Sub CommandButton1_Click()
ThisWorkbook.Sheets("Sheet4").Select
End Sub

Otherwise you could refer to the Actual Sheet as follow;

Private Sub CommandButton1_Click()
ThisWorkbook.Sheet1.Select ' which is named Sheet4
End Sub

Hope that helps.

Why would you want to use code for that? You don't need code at all for this kind of functionality.

Insert a shape into the sheet. Select the shape and create a hyperlink. Select a location in this workbook, select a sheet and click OK.

See attached file. No code. Each sheet has buttons that link to each other sheet.

Originally Posted by Marieme

I actually want to open 2 sheets at the same time.

How does that work? What do you expect to see?

Well, as you rightly state, it does not make sense to link to the sheet that you're already on. Therefore, the button that navigates to the "current" sheet is grayed out and does not have a link. That is the user experience we want, right?

This does not happen automatically, but is the result of a little extra TLC required for a positive user experience.

So, I created 5 shapes for Index and sheet 1 to sheet 4. I created these shapes on the Index sheet. I added links to the respective sheets on ALL buttons.

Then I selected all the buttons with Ctrl-Click and then pasted them into the other four sheets.

Then - magic!! - I edited each sheet and manually removed the link and changed the color of the button that referred to the current sheet.

This is almost a reflex action for someone who does web design or other navigational user interfaces.

It does not happen automatically, but the manual intervention required to create a seamless and logical user experience does not take long.

It's all about how much you care about the user experience.