1. O

    Multiple Hyperlink/VBA Query

    Hi All I was just wondering if anyone could help me with a Multiple Hyperlink/VBA query. I've tried multiple methods but none seem to be working. I have a list of names where I want there to be a hyperlink option next to each individual name that will take the user to another page when...
  2. N

    Excel hyperlink to scroll to specific section of active sheet.

    I know you can link directly to a cell pretty easily with an image in excel, but what if I want it to have the specified cell show AT THE TOP of the sheet? What happens now, is the hyperlink does take me to a specific cell, but it scrolls to the bottom of the sheet. I would like to have the...
  3. B

    VBA Challenge! How do i save the fidelity of a VBA Hyperlink?

    Hello everyone I would like to thank you all in advance for your kind help, I have a good working knowledge of excel, BUT I am rather new to VBA and I could really use some of your help. So I was able to create a simple formula that looked at cells Sheet2 A8 and B8 to create a hyperlink in C8...
  4. B

    Hyperlink to a specific cell

    I was wandering if there a way to have a hyperlink to a specific cell in a workbook? I email hyperlinks to excel workbooks thats on my network at work all the time but It would be nice if the link actually opened the workbook and went to a specific cell or row.
  5. D

    Replace HYPERLINK formula with button

    I've created a link with the HYPERLINK formula which is using customer IDs from another cell inside the Hyperlink. Works like a charm. Now I've been trying to make the Excel a bit nicer looking. Is there any way to replace the links with a button or a button-like graphic so it doesn't just look...
  6. P

    Hyperlink icon or Hyperlink formula

    Hi, I am creating a summary sheet book with hyperlink icon or hyperlink formula to the another workbook “datasheet“ however i found the below issues. 1. For the right click and create hyperlink, it is easy to do but when I save as the summary sheet workbook and the another workbook "datasheet"...
  7. U

    VBA hyperlinks in Excel

    Currently in the middle of an assignment where you have send an excel file as a hyperlink rather than an attachment using VBA, Is there any possible way to do this as at the current moment I am only able to send the location of a link as regular text rather than a hyperlink. Any help would be...
  8. M

    VBA Hyperlink

    Hi Guys, I am asking about hyperlink function in VBA, I have the following Label1 = "Link from excel cell" I need to add hyperlink to it and i did the following ThisWorkbook.FollowHyperlink Label1 and it works perfect, but what i need is (Friendly name) not to put the link shown in excel cell...
  9. R

    Allow Access to Hidden Sheets

    Greeting, I need to create a workbook which only has the first sheet visible to force the user to go through a process. On the first sheet I'm using the HYPERLINK function in conjunction with a VLOOKUP to create a variable hyperlink to multiple possible destination within the same workbook...
  10. sharky12345

    Efficient method to add hyperlink

    Afternoon guys, I'm trying to find an efficient method to add a hyperlink to a range of cells but what I have so far keeps generating an 'Out of memory' message. The code itself runs fine, but once it's complete I get the message. This is what I have so far: LastImportRow =...
  11. I

    make chart axis labels hyperlink to other pages

    I have an Excel bar chart I would like to make the chart axis labels hyperlink to other other charts that contain additional details about the specific tag of interest. Is this possible?
  12. T

    #NA error on one System.

    The below is a perfectly fine hyperlink formula. On one system it works fine.. however on another system it throws an error. I believe there is some setting in EXCEL OPTIONS or WIN10 that I need to check or uncheck. The below Hyperlink takes the cursor the last row containing data (TEXT or...
  13. L

    selecting a cell which has email address (hyperlink)

    Hi I have lets say 5 cells. The first one has an email address in hyperlink format (blue underlined). How can I select these cells (highlight them). when I click on the first one it will open the email address. It wont allow me to select cell A1. So I went to A5 first, selected it then drag the...
  14. J


    I want to build a hyperlink or a macro which when clicked on will open an new Outlook email with a copy of the file and the email address automatically populated. Is this possible? Ian
  15. N

    Dynamic YouTube Timecode URLs in Excel

    Hello, all. I enjoy indexing chapters for long YouTube videos, so that others can jump to the topics which interest them. For example, someone has created a series of videos with a brief overview of every Family Computer/N.E.S. game released in order of their original publish date. The 2...
  16. F

    using Hyperlink function to extract Google kilometers into Excel Spreadsheet automatically

    Dear members of the forum, I'm struggling with a mind-numbing task that needs immediate automation. While we're looking for cheap alternatives to employ for automating kilometer calculation from point A to point B, I thought it's best to inquire the forum what are the possible options to 1)...
  17. L

    Create hyperlink via userform

    Hi all Not sure what is going on with this, I need my code to add a user selected hyperlink through the dialogue box, into a table on a different worksheet. I don't want to overwrite the current cell value with the screen tip either, What it is doing, is adding the root part of the hyperlink...
  18. J

    VBA code to Modify Formula using new External Workbook Hyperlink

    Hi, I have a Workbook that serves as an aggregation of data from several other external workbooks (same file directory). The workbooks being referenced are all uniform, so the specific sheet and cell reference is always the same in a column with the only thing changing being the workbook name...
  19. D

    Hyperlink missing by set number of rows

    I have 2 tables on separate sheets that each has its header starting at row 5. I have a formula that hyperlinks from a cell in one sheet to a corresponding cell in another sheet based on a value in a column on my first sheet. I'm using structured references in my formula which maybe the...
  20. D

    Tex & Hyperlinks Sharing Single Cell?

    Hello, Is there a way for one single cell to share both text and a hyperlink? For example, I want a cell that describes something, and then after the description, I'd like there to be a hyperlink that would access a webpage extending the topic? So the text body is separate from the hyperlink...

Some videos you may like

This Week's Hot Topics