Check box links to another cell in another worksheet

[TPD]

Can someone tell me how to have a check box automatically open (hyperlink) another worksheet in the same workbook?

What I need is for when the person clicks to place a check in the box, it takes them right to a specific line in the next worksheet.

Example info:
Worksheet name that I need them to be re-directed to:VEP Discovery

Cell I need them to be directed to in the VEP Discovery worksheet: A48

Any help and clear direction would be greatly appreciated for this non saavy Excel user...

Thanks so much!
Todd

[VBA Noob]

Hi,

This link should help

http://www.meadinkent.co.uk/xlnavig.htm

VBA Noob

[TPD]

Thanks, but the problem with that is that I have a button and I cannot get the hyperlink option to appear with a button. I think I would need to edit the macro that goes with the button, but not sure what code to put in and where to put it within the default button code.

td

[VBA Noob]

Hi,

Think you need to add this code to your macro somewhere.

Unless you change your tick box to a Text box which allows you to assign a macro and Hyperlink

Please Login or Register  to view this content.

Here was another hyperlink way

=HYPERLINK("#'VEP Discovery'!A48","Click Me !!")

VBA Noob

[TPD]

VBA Noob,

I owe you a free lunch!!!!! Thanks so much!!!! The formula worked.

Todd

[TPD]

Sub Link()

Sheets("VEP Discovery").Select
Range("A48").Select
End Sub

This formula worked,..but I neglected to ask for one more thing...yep,...the backbreaker!

Can I add any code that will perform the action above if the sheet is hidden?
I need to hide the sheet. SO basically I need that one action to not only take you the spot as shown above on that particular sheet, I also need it to unhide the sheet first so that it can do this.

Thanks,
TD