hyperlinks

  1. J

    Pulling data from cell to fill in a link

    Hello guys! Firstly, feel free to save time and jump straight to the TLDR bold section below, then read the rest of this long post only if more context is needed to help. This is probably a super easy problem for most of you, so trying to respect your time here, but also include context incase...
  2. W

    Userform picture based on a combobox selection

    Good morning all, I've seen a few posts on here but haven't found a situation similar. On Sheet1, I have a list of all employees. On a local drive I have a picture of all employees which I would like to hyperlink to the name...that's the easy part. My userform has a combobox that's populated...
  3. L

    VBA: Hyperlink to image placed in comment, multiple sheets

    Hi, I am struggling to make a hyperlink into a picture into a comment. I am exporting checklists to excel where the user has to take pictures for some of the checkpoints, and when I export them, they appear as hyperlinks in excel. Now, I want to transform these hyperlinks into images placed in...
  4. P

    Auto-Scrolling from Hyperlink in Multiple Sheets

    This is a followup question of a previous query I posted. In that thread, I was looking for a way to have Excel automatically scroll so that the hyperlink's target cell would appear in the top-left corner of the screen. Fluff was kind enough to provide the following solution (thanks again!)...
  5. P

    Auto-Adjusting View for Multiple Hyperlinks

    I have a single worksheet with lots of data in multiple tables. I'm looking for a way to let other users navigate to the specific data table they need. To resolve this, I created a series of hyperlinks leading to each table. This works fine, but the cell each hyperlink leads to would always be...
  6. R

    Hyperlink Inquiry...

    Hello Excel Experts, Need help with this situation as can not find a way on how to do it. I have 2 sheets in a workbook. Sheet 1 has a data that has a hyperlinks to different sheets in the workbook. On sheet 2, I have created a filter function to extract the data on sheet 1. My issue is the...
  7. A

    Automatically add hyperlinks when typing a serial number

    Hello! I work for a company that sells and services pumps. I am attempting to make a excel sheet that will give us an overview of the pumps we service and sell. I would like to make a macro that will automatically add a hyperlink to a file with the same file name on our server when i type the...
  8. M

    Find and replace in all sheets, and replace in exact format and properties

    Hi, I got this code from another post. The solution is amazing and really helps me. I would like to know if there is a way so I can 'Find' and 'Replace the exact value' The values I'm replacing with are hyperlinks. So I would like to replace the new values with those hyperlinks and keep them...
  9. M

    Hyperlink warning message

    Good afternoon one and all, This is driving me mental. I have multiple .mp3 files on an external hard dive in various folders. I have created hyperlinks on an excel spreadsheet to open them. When I click on any one I get a warning message telling me that some files are harmful, Can I disable...
  10. S

    Repairing Hyperlinks in a Workbook

    Greetings, When Excel crashes my hyperlinks placed throughout the workbook break. I am trying to create a macro that will fix the paths of all the broken hyperlinks. This is what I have: Dim hl As Hyperlink For Each hl In ActiveWorkbook.Hyperlinks Debug.Print hl.Address...
  11. D

    Grabbing HTML data from hyperlinks in excel

    Hi all, I have a document with a column of 400 hyperlinks for different companies. Each link is to a website with a description of each company. The link leads to the same sight and while the description changes for each company the format and location of the description does not change from...
  12. K

    VBA validation list delimited separator

    Can someone explain why adding hyperlinks before adding validation switches from "," to ";" which is default xlListSeparator? Sub test2() a = Join(Application.Transpose(Selection.Columns(1).Value2), "; ") Selection.ClearHyperlinks Selection.Validation.Delete...
  13. E

    Stop Excel hyperlinks from opening in a web page

    At some point, my hyperlinks (that use to open up in Excel) started opening up in a web page. I think this is due to a global change that IT made in at my company (not sure). I am looking for a setting to stop this from happening. I am using simple hyperlinks to open other Excel workbooks. I...
  14. D

    Hyperlinks in unprotected cells in Protected Worksheets using VBA

    Hi I am having problems inserting Hyperlinks in unlocked cells on protected worksheets. With the help of this forum I have been successfully using the code below to auto filter However, I have noticed after this code is run, I am unable to insert a hyperlink in the unlocked cells. I have...
  15. B

    saving hyperlinks between Workbooks

    I am having problems with losng my hyperlinks when I save the exel spreadsheet to another workbook name. Is there any way to save my hyperlink info to another workbook so it appears in the new workbook. Any help would be greatly appreciated!!
  16. W

    excel hyperlink issue

    I created a monster. I have a workbook that isbeing used as an index of all our documents. Each row represents one document and each row is made up of several columns. Each row has a hyperlink that spans the entire number of columns . The hyperlink is to a scanned document on the network. They...
  17. B

    Lose Hyperlinks when saving file to new name

    How can I retain the hyperlinks when I save my excel file to a new name
  18. C

    excel hyperlinks

    I have a column of unique text values that are URLs (web addresses). I need to convert all of them to hyperlinks that point to the unique URL but want all of the rows to display the same text. My actual dataset is hundreds of rows. Data www.1234.com www.5678.com www.9101.com Desired output...
  19. A

    Hyperlink retured through a VLOOKUP gives error

    I have created several worksheets including one that holds my look up tables (worksheet labeled tables). I also have another worksheet called "Directions". In the "Tables" worksheet I have an array with three columns, the first holding the text value I am searching for, column two which contains...
  20. O

    Hyper links when source worksheet hidden

    Can anyone help me please? I have a workbook with multiple worksheets. Worksheet#1 is the one that the user will beactively using. It has hyperlink to other worksheets within the sameworkbook. These other worksheets areinformation only. When I hide the otherworksheets, the hyperlinks stop...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top