Results 1 to 2 of 2

Make hyperlink target show in the first (ie left most) column

Threaded View

  1. #1
    Registered User
    Join Date
    12-15-2017
    Location
    Cornwall, England
    MS-Off Ver
    2016
    Posts
    7

    Make hyperlink target show in the first (ie left most) column

    Hello clever people,

    I have a simple worksheet and have added hyperlinks to specific sections of the worksheet. Currently when I click on a hyperlink, it works fine, but the target cell is shown in the far right column. I would like the target cell to show in the first available column on the left.

    I have attached a simplified version. Is it possible for the hyperlink target to always show in the 3rd column from the left (ie next to the staff name)?

    Thank you.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how to make my code work with target.column instead of target.address
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-18-2017, 09:29 AM
  2. How to make cells show blank based the cell to the left
    By ScottKiwi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-18-2015, 03:57 PM
  3. Show column to left of named range when clicking hyperlink
    By Crispld in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-31-2014, 06:48 PM
  4. [SOLVED] Show row and column values for the target cell
    By Endre111 in forum Excel General
    Replies: 17
    Last Post: 09-09-2014, 12:01 PM
  5. [SOLVED] Replacing 0 in a column with target value in left hand column
    By gretchenwhitcomb in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-11-2013, 03:21 PM
  6. Hyperlink target showing on top left corner of screen (Using image not cell)
    By Mo T in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-29-2013, 03:23 AM
  7. Replies: 2
    Last Post: 10-27-2005, 04:05 PM

Tags for this Thread

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