hyperlink

In the Xl2bb shown below, you see in cell A3 the value A21 which is based on cell C21. The issue I have is when a listed program changes row number in sheet ProgramLocInfo then I need cell A3’s value to reflect that in the hyperlink. When a program changes row number in sheet ProgramLocInfo then...

I am currently in the midst of making a small library of links in Microsoft Team Excel. Where I have met a wall, where I cannot use the link, as they are redirected due to the including ampersand in the title. Example: xxxxxx.com/xxx/xxx/?action=show&product=301 Which is translated to...

Hallo, es darf kein Blattschutz und/oder Arbeitsmappenschutz aktiv sein. Hat der Name der Quelltabelle ein Leerzeichen ist es für den Ablauf des Makros kein Problem, aber der neue Name der Kommentartabelle darf keine Leerzeichen beinhalten und nicht zu lange sein. Das Makro fragt den Namen...

Hello, sheets and/or workbook shall not be protected. If the name of the source sheet consists of blanks this is no problem for the running of the macro, but the name of the new comment sheet shall not consist of blanks and shall not be too long. The macro asks for the name of the source...

Hello I hope some genius out there can help me. I have a cell in sheet 1(call it the source cell), hyperlinked to a hidden sheet. The text in the source cell and Sheet Name are the same, so when i select the cell, the hidden sheet opens. Here is the VB routine i am using: Private Sub...

Hi guys !!! How are you ? I need the VBA code fore Hyperlink. I have big DB and I want integrate Hyperlink to column E ( Report Number ). All reports scanned and store on the server Example ( Z:\QM\04_Piping\03_Visual & NDE Request Report\VISUAL 201 - FIELD ) Also I have 2 notes about the...

Hey guys ,im having trouble inserting a formula into a shape..and making it work can someone help me with it The Formula....=HYPERLINK("[6.Shop Workers.xlsx]"&ADDRESS(1,1,,,$G$3),"Click") ABCDEFGHIJKLMNOPQRSTU123101JebastinSalary Date4501-08-2020678Salary 10,0009101112Leave0ClickTotal...

Hello, I am trying to copy a hyperlink from cell A2 from Worksheet 2 to cell B3 of worksheet 1. The text in both cells should remain unchanged. Any help would be very much appreciated. Thank you in advance Kristina

Hi, i am wondering if this possible. I have created a little database within excel. One table i have in this database is the following (see below). These "From and "To" fields are for a serial number. The user enters a serial number on a userform, and it pulls through the row from this table...

Hi , I want to create a Hyperlink in Sheet2 of column 1, that direct to the address mentioned in sheet2(Rowno and Column) to Sheet1. Attached the Excel Sheet for your reference. Thank you in advance. Sheet1...

Hi all, I have been playing with this little project recently which, as the thread title states, allows for adding an hyperlink to the native vba MsgBox. At the moment, I managed to make this work with only one hyperlink per MsgBox... This little "tool"can come as a handy, a quicker and a more...

Hi, I need some help if possible. I have a workbook with some information in a table ("Sheet!") which gets added to information in a form in a second sheet ("Sheet3"), sheet3 then gets saved using a variable from cell I6 as an excel sheet. If possible I would like to add a hyperlink into the...

Hi, I have posted a couple of requests on some forums with great suggestions, but nothing has quite worked. My scenario: I have a couple combo box dropdowns that will update a cell A1 (Range Name of URL) with a HYPERLINK formula (=HYPERLINK(XLOOKUP(A2,'Report Links'!$AJ:$AJ,'Report...

Hello, I've a "search" page that loops through all the sheets to return data to my search page and produce a hyperlink to each sheet said data is found. One of the search criteria is from a data validation list. I believe this is messing up the ordered list of search results. I have the code...

Hi all! This is my first post on here so I hope someone can help me out! I have a pivotchart in Excel and when I use double click it brings me to a new sheet what is nice. Now I want to link some cells in a new sheet with this pivotchart by using a hyperlink (right mouse click on the cell and...

Hello all, Been using Excel 2016 for many years now. I have a large workbook that I use for my department training checklists. I have a mater check list that I use to populate for all employees training. The document has multiple worksheets that has macros, text, and hyperlinks in some...

Hi guys Anyway create hyperlink that linked to a specific text? (The range of sheet is changable and this text may A10 and after entered data will be A11 and ...)

Hello - I receive an email every day with a link that takes to me to folder. That folder houses a PDF I need to share with colleagues. I've asked that the email contain the PDF rather than the link but have been told it will take some time. Is there a way I can run a macro in Outlook to click...

Hi everyone, I am quite new to using VBA and I am having issues using hyperlinks. Essentially I am trying to create a table of contents where if I select the hyperlink (In the same document) on the table of contents sheet it will simply direct me to the following sheet i.e. selecting page 1...

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