1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Microsoft Excel Links

Discussion in 'Other PC Software' started by NJTech30, 2009/01/30.

  1. 2009/01/30
    NJTech30

    NJTech30 Inactive Thread Starter

    Joined:
    2002/07/16
    Messages:
    54
    Likes Received:
    0
    I have created a spreadsheet that has links in cells to other worksheets within the spreadsheet. I am wondering if I can have the cell highlighted once I click on the link. It takes me to the worksheet that it is linked to but it is hard to distinguish which cell has been selected. I am using MS Excel 2002 SP3. Is there a macro that I can create that will highlight the cell with a different color?
     
  2. 2009/01/30
    Bilb0

    Bilb0 Inactive

    Joined:
    2007/07/23
    Messages:
    203
    Likes Received:
    6
    Well, the text should change colors on all accessed links, but if it'll help I'll work out an OnClick event in VBA which would change the Fill color of the cell.
     

  3. to hide this advert.

  4. 2009/01/31
    Bilb0

    Bilb0 Inactive

    Joined:
    2007/07/23
    Messages:
    203
    Likes Received:
    6
    Well, I am unable to find a way to initiate an OnClick event for cells in Excel.
    Assigning an event for objects such as text boxes, etc, is no problem.

    Surely though, the color of the text link should change though.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.