1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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!!
  7. 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...
  8. 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
  9. 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...
  10. 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...
  11. 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...
  12. Q

    Hyperlink function from drop down menu data validation list throughout entire workbook

    Hello need a little help "YouTube": Hyperlink function from drop down menu data validation list throughout entire workbook "YouTube": https://www.youtube.com/watch?v=3vRkA_7x9t8&t=50s The validation link hyperlink listed above works great but it links to other sheets and I need it to link on...
  13. B

    VBA to Convert Paths to Hyperlinks and Group by Folders

    This bit of code does a great job of listing all folders and files in a directory to a sheet. Sub cmdList() Dim sPath AsString Dim fOut AsVariant Dim r AsInteger Dim Cell As Range With Application.FileDialog(msoFileDialogFolderPicker)'.Title = "Select directory"...
  14. B

    Hyperlinks in Text Boxes

    Is there a way to place multiple hyperlinks in a single text box? Every time I select some text to make into a hyperlink, it makes the entire text box the link. I have a long Excel workbook comprised of long text boxes for ease of alignment purposes. I'm using Excel instead of Word because...
  15. Jym396

    Hyperlinks for other users

    When creating a hyperlinks for other users, upon looking further, hovering over the link it shows the directories, the file path of MY computer. i'e. file///C:\Users\User\Documents\Excel\filename.xlsm. No wonder I can't share it. Thanks, ~Jim
  16. G

    using SMALL, INDEX, with IF conditional adding a HYPERLINK

    I'm wondering if anyone can help me with working out how to add a hyperlink based on certain conditions. I have two worksheets - Worksheet "Catalogue" has a dropdown list to select which fruit and another worksheet which has information about the piece of fruit selected. There are multiple...
  17. N

    Click on number, which pastes that number in another cell

    Hey all! I scoured the internet and I'm either not finding how to achieve this, or I'm describing my need incorrectly. Hopefully someone can help here! Basically I created a calendar in excel. I want to be able to click on a date, and have that date appear in another cell. Is this possible...
  18. B

    Updating Hyperlinks When Page is Copied

    I have a rather large workbook that has a 'Template Page' where the default page styling, formulas, and tables reside. I have a Macro that clones the page, and then auto updates the formulas to refer [NewPage] instead of [Template] page. All works well, no issues. Then now they want to put in...
  19. A

    Hyperlink error during macro run

    Keep getting a error This Location may be unsafe. Hyperlinks can be harmful to your computer and data, click only those hyperlinks from trusted sources. How do I turn this off or add as a trusted source?
  20. DataBlake

    Check If Hyperlink Broken But Only Unique Cells

    Hello all, I have a predicament where if i run a hyperlink checking VBA sub i may not see my computer for the rest of the evening as it will check over 100,000 hyperlinks Is there any way to have it only check the first of every hyperlink? basically there are duplicate hyperlinks and i would...

Some videos you may like

This Week's Hot Topics