hyperlink

  1. P

    Hyperlink works in Outlook and Teams not in Excel

    We are having that issue if the link is clicked from Excel to a Coupa application. It works fine with Outlook and Teams application. Is there is any Excel setting we need to change to make it work? Thanks for your help
  2. G

    Hyperlink for first column of each row running a macro ?

    Hi First up all thank you very much for this wonderful forum. I am not good in vba. so I need help from you wonderful people here. I am looking for something like this I have an excel file which contain two sheets. The first sheet contain my data in rows, the second sheet is a template which I...
  3. J

    Remove link, maintain text formatting

    I have an Excel file, converted from Acrobat, that contains a cell containing some address text with formatting (different colored text, bold, size difference, etc.). The entire cell, however, is a link, so that if I simply click the cell my email client opens and wants to send an email to the...
  4. T

    Excel VBA Create a link to another worksheet only if a cell is populated

    Hi, I am trying to create a button that I will click and it will transfer me to another worksheet but only if a cell is populated. If the cell is not populated I want a message box to warn me and not go any further until the cell is populated. I have so far done this but it just takes me to...
  5. B

    HYPERLINK() function not working with VBA .Follow

    Hello, I'm not a power user but I tried to google my problem for hours and couldn't find an answer so I landed here seeking for help. The situation I have made a URL with CONCAT function that looks something like https://blablabla.com/date/something/variables. In another cell I used HYPERLINK()...
  6. R

    Database form that can capture file address and save to cell in hyperlink format

    Hi, I have a database form that captures information off a physical form using a simple vba program. The physical form, once signed off, needs to be scanned and saved to a network folder. When the clerk is capturing the form in VBA, I would like them to be able to add a link to the copy of the...
  7. M

    Dynamic hyperlink tied to a button in Excel

    I want a concat'd hyperlink tied to a button, that when clicked, goes to a website, which would be the dynamic input of what the user entered into a cell added to the end of a static website address I have in another cell. I'm using this function to search a website that puts the user input at...
  8. T

    Automate: Hyperlink at top of Sheet that links to each section of sheet for multiple workbooks

    Scenario: I have multiple workbooks(20+). They all have a worksheet with the same name (ABC). Sheet ABC has 3 sections and these sections begin with the title of the section e.g. Section 1, Section 2 and Section 3 Issue: There are many rows (2000+) separating each section. Issue 2: Each...
  9. G

    Hyperlink that links to a cell relative to the sheet the hyperlink is located in

    Hi, I'm creating an excel sheet for a friend who is even less well versed in excel than I am and I'm having trouble making a hyperlink that just points to a cell, no matter what sheet that the hyperlink is in. Here's an example: I have a workbook with one sheet in it, Sheet1. In cell A1 of...
  10. M

    VBA to open Excel workbook from Sharepoint site and by pass "Open" requests

    Hi, The code below opens a workbook on our sharepoint site. The "Application.EnableEvents = False" bypasses the "Open / Cancel" request that appears at the bottom of the IE 11 but then the Downloads Box appears where you need to click open. How can you open the workbook and suppress the various...
  11. J

    Setting the target of a hyperlink based on first instance of a cell's value found in another sheet

    I am trying to type a positive integer into column A of sheet1 and have excel automatically turn that cell into a hyperlink to take me to Column A, Row [that value] of sheet2. So once I type a number, say "5," into sheet1 column A, any row, I want Excel to search sheet2, Column B for the first...
  12. J

    Help writing a hyperlink reference to another worksheet based on a number in a neighboring cell

    I'm using Excel 365 with Windows 10. I want to create links inside my excel file and am having a lot of trouble combining different formulas inside one cell to make a link. I have one workbook named "Trade Log" with two worksheets named "Trade Log" and "Screenshots." In the Trade Log worksheet...
  13. C

    Email Hyperlink

    Hello: When I click an email hyperlink, it currently opens to the Mail app. Is there any way to have this switched to Outlook? Thanks OJ
  14. 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...
  15. 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...
  16. 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...
  17. 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.
  18. 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...
  19. 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"...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top