+ Reply to Thread
Results 1 to 2 of 2

Hyperlink to another Worksheet

  1. #1
    Registered User
    Join Date
    12-26-2008
    Location
    Singapore
    Posts
    18

    Hyperlink to another Worksheet

    Dear Pros,

    Hi, I am a beginner. I found an question again. Hope can get help again.

    I have a button in one of my worksheet. and i have assigned an macro to this button. Below is the Code

    Please Login or Register  to view this content.
    This button is just a simple function to select another sheet.
    If i want to create a same function like this macro, but i would like the user to click the cell which contain certain words. Do you think it is possible?
    Can i use Hyperlink?

    Hope to hear from you soon ^^. Thank you in advance

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Hyperlink to another Worksheet

    Do you mean to use the Hyperlink function ?

    =HYPERLINK("#'My Sheet'!A1","Click Me")

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1