Resolved >>> Macro to go to specific sheet upon choosing option

[mccrimmon]

Hi Guys,

I was wondering if you could help.

Im looking to create a macro that goes to a specific sheet on my workbook upon selecting an option.

Example being I open the spreadsheet and a list of options come up such as:

BRIAN
JOHN
JAMES
PAUL
STEVEN

Upon selecting one of those names you are transferred to the sheet named "BRIAN", "JOHN", "JAMES" etc etc etc

Thanks in advance.

[VBA Noob]

Why not just use hyperlinks. Right click "Brian" and select hyperlink > place in document > select sheet "Brian" cell A1


http://www.bettersolutions.com/excel...N011417330.htm

http://www.bettersolutions.com/excel...I911118770.htm

VBA Noob

[mccrimmon]

Problem now resolved.

Ive created a userform that opens when my workbook opens. The userform then allows me to active the certain sheet before closing the userform.

[VBA Noob]

I was going to suggest this link but spotted you found a solution

Worksheet Navigator Toolbar

VBA Noob

[royUK]

There's a few options here as well, see the navigat workbook part

http://www.excel-it.com/vba_examples.htm