hyperlink

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...

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...

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...

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...

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

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...

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...

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...

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.

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...

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"...

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...

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...

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...

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 =...

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?

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...

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...

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

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...