+ Reply to Thread
Results 1 to 2 of 2

Link to a sheet WITHOUT using hyperlink function

  1. #1
    Registered User
    Join Date
    07-22-2011
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    1

    Link to a sheet WITHOUT using hyperlink function

    I will be uploading my excel document to googledocs and the hyperlink feature really isn't very compatible.

    So here is my issue.......

    Sheet1 in Column A is a list of about 300 Account names.

    Each account has its own respective sheet in the workbook.

    When I click on the account name (the cells in column A) - I want it to link to the sheet for that account.

    I've tried everything I can think of - Please help!!

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127

    Re: Link to a sheet WITHOUT using hyperlink function

    Are the names in column A identical to the names of the individual sheets? If so, I'd suggest using a double click event (ie, whenever you double click on a name, it will jump to that sheet.

    Check the attached workbook and let me know if it helps.

    NOTE: The code is in the Sheet1 code module.
    Attached Files Attached Files

+ 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