Command Button to Open Other Worksheets

[kstvns]

Using MS Excel 2003 with Win XP OS.

The sheet tabs will not be visible to the user. What is the code to assign to a command button that will open another worksheet in the same workbook? I think this will be better than using creating a hyperlink.

Example: On Sheet A, a click on the command button (named Go to Widgets) will be open Sheet B (Widgets).

 

[njimack]

Sheets("Widgets").Select

 

[kstvns]

Thanks! How simple that was!

To add to this, I inadvertently pressed F2 and got what I have been looking for all along.

 

[kstvns]

Run-time error 1004. Select method of Worksheet class failed.

What does this mean?

 

[kstvns]

In reading other posts with similiar problems, the problems seems to be because I have the sheets hidden. Is there another way for this code to work with the sheets hidden?

 

[GK039]

Try this

Worksheets("sheet2").Visible = True
Worksheets("sheet2").Activate

Where sheet2 will be your sheet name

George

Using MS Excel 2003 with Win XP OS.

The sheet tabs will not be visible to the user. What is the code to assign to a command button that will open another worksheet in the same workbook? I think this will be better than using creating a hyperlink.

Example: On Sheet A, a click on the command button (named Go to Widgets) will be open Sheet B (Widgets).

 

[kstvns]

Try this

Worksheets("sheet2").Visible = True
Worksheets("sheet2").Activate

Where sheet2 will be your sheet name

George

Thanks, George! That seems to work!!

BTW, is it wise to use the codename of the sheet vs. the sheet name? If so, where would I insert it in the code?

 

[GK039]

Your welcome

No difference what name you use as long as it is always in "" ""

George

Thanks, George! That seems to work!!

BTW, is it wise to use the codename of the sheet vs. the sheet name? If so, where would I insert it in the code?

 

[kstvns]

Your welcome

No difference what name you use as long as it is always in "" ""

George

Can the worksheets cannot remain hidden with that code?

 

[Sthrncali]

You just need to unhide the sheet you want to open, then hide the sheet you were coming from.

like this:

User is on Sheet1 and clicks the button to open Sheet 2:

Sheet2.Visible = True
Sheet2.Activate
Sheet1.Visible = False

Then reverse to go back to Sheet1:

Sheet1.Visible = True
Sheet1.Activate
Sheet2.Visible = False