hyperlinks

Hello, This appears to be a common problem experianced by people but I am having trouble getting around it. I have absolute hyperlinks on my excel spread sheet and when it is saved Excel appears to remove the folder that the workbook is stored in from the address. I also have other...

Hello, I'm using the code below to decode a list of hyperlinks in column A however, id doesn't grab the full URL. All of these links go to different bookmarks within the same website page. Example: The full URL is...

I'm hoping someone can help. I copied and pasted a long list of hyperlinks to a new spreadsheet in Excel 2016 in my Windows 2010 OS. The hyperlinks are now a mix of colors. Some are the standard "Hyperlink blue" and others are black. I found the following on the Microsoft Office Support site...

I have MS Word and Excel for Android on my new Android tablet (Samsung) I'm a musician who wants to use it on stage. On a Win PC I worked out an elegant little spreadsheet that allows me to see my set lists and punch up the charts for it with a tap using a hyperlink to a docx file. No...

I am creating an MS-Excel sheet, with hyperlinks, which would point to other MS-Excel Workbooks, in various network, locations/file folders. How do I create a hyperlink, using Insert, pointing to an MS-Excel Workbook, Sheet10, Cell M100. (As an example, and the file is located in a network...

Hi all, I have an excel file saved on our server that contains hyperlinks to various folders/documents/pdf's across our server, I want to save the excel file to another location on the same server but when I do that the hyperlinks stop working. I've tried changing the hyperlink base to x and...

Good Afternoon and thanks in advance for any help! I am working with a 500 page workbook.:eeek: Every year the tabs have to be renamed to match the date of Friday each week. The first page of the workbook is a directory with hyperlinks to all other tabs. Q1. How can I quickly rename 500...

Sub Button5_Click() Worksheets("sheet1").Range("J3:P17").Value = Worksheets("sheet3").Range("A2:F16").Value End Sub Hi All, I am facing some issues with the above formula. I have created a button and added above mention code to it. It shows all the values within Range A2:F16 on sheet 3 in...

I'm thinking it should be fairly easy. So I have about 45 similar tabs, each with columns stretching to the right showing different periods (eg. P1 starts in cell C3, P2 starts J3, P3 starts Q3, etc.). On the first tab, I created hyperlinks on the left hand side so that someone can click on...

Hi All, Hope you can help i have the following code which when you click a customer's number in column A, starting with row 3, will link to another sheet within the same workbook to show just their details from their row. There are 35 columns in total. The code works, however, the whole sheet...

Below is a piece of my code. Unfortunately, I'm not able to download onto this computer, therefor I can't upload files to share. I'll try my best to explain. I have a spreadsheet that contains a Summary tab. One macro will create new tabs. On those, I have a cell with the title. The Summary tab...

Hello! https://www.mrexcel.com/forum/excel-questions/428957-list-worksheet-names-using-formula.html I am referring to this great thread posted here a while ago. Formulas work beautifully, but I would like to ask for help on how to add automatic hyperlinks to the names of sheets that appear in...

Hi! I’m hoping for a macro that can: Start in A36 of the active worksheet and continue downward, stopping when it reaches a blank cell (ideally, it could do this at once for all selected worksheets, if multiple are selected.) In each of those applicable cells, insert a hyperlink to the...

Hi All. I have this wonderful code that did amazing things in XL2003 and earlier Win OS. It doesn't work in XL 2013 on Win7/8. Can someone assist with modifying code? Thanks I think this code was modified by David Kaufman. Option Explicit 'created using John Walkenbach's "Microsoft Excel...

Hi folks, I have an issue with excel hyperlinks not working. The spreadsheet was created with a different program and it has used "#" in the hyperlinks. Is there a simple solution (hopefully VBA) that can search and replace characters within a hyperlink? Usually I would manually update...

I have a long list of hyperlinks I need to open and print. Is there a macro sequence that will open hyperlinks that reference another column. Example: =hyperlink("path"&A3&""&A4,"A5") I've searched everywhere for a formula to open it but it seems the thing stopping them are the references to A3...

Hi All, Post#1 i have an issue where a user creates a excel sheet with links to a program, not a website(these work) that changes the {i into an ASCII character %07d or something like that and i get an error say a web capture has failed to due to an error. Does anyone know what could be...

I have a dilemma. I need to present cells with both an LOV and make it a hyperlink. I can use data validation to create a dropdown list of values in a set of cells. But in that same set of cells I need for each cell to be a hyperlink to an area where the user can enter notes pertaining to the...

I have a workbook with a template page that gets copied for each new country we add to a project. There are hyperlinks that lead to places within the page (go to bottom, go to top). I successfully created a macro to copy the template page and add it to the reports, but users still have to...

I have searched for add-in's, various terminology, and I'm coming up with very little in regards to my question. I have a workbook with multiple pages (over 40) with 20 "sectors" in each. A total of 800 named ranges. In order to create the index or menu in a matrix style where you click on a...