hyperlinks

Hi, I have a worksheet with lots of hyperlinks to files. I have moved all the files into a subfolder of their previous location called Archive. I want to edit all the hyperlinks to include "Archive" in them. They are relative hyperlinks. In my head this should be easy, but I can't work out a...

Hi, I have a dashboard of 40 worksheets. I have a menu with hyperlinks to the 40 different worksheets with shapes. I have put within the cell to give it a nice three dimensional look. I want to keep the 40 worksheets hidden until someone clicks on the hyperlink with shapes . Is there any way...

Hi all, I'm a newbie and need help. I have Excel 10. I have a spreadsheet containing a single Column (A) which contains a list of URLs which have hyperlinks associated with each URL, of which there are a lot of duplicates. Say Range (A1:A25). 15 of the 25 are duplicates, thus 15 duplicate...

Hello, I have a list of hyperlinks to documents in an excel column that i created by specifying the folder path then adding the doc names and ".doc" to the end. However, some of the links are broken since some of the documents have a ".docx" instead. Is there a way to go through the list, check...

When I use the Format Painter to copy the formatting of a cell with NO hyperlink to a cell WITH a hyperlink I lose the default (and desired) blue hyperlink font color. The link is still there, but the font color changes to the source font color. These are hyperlinks that were added by...

Hi All I have a spreadsheet where I have inserted Hyperlinks to make it easier to get to certain websites Is there anyway of also getting these to auto log in when clicking on them. This way to save having to log in also Thanks

Hello.. I need some nifty code that will add hyperlinks to cells where there is a corresponding tab with the same name in the same workbook. I have a summary worksheet with many test names in column A. There is a tab for each test. I'd like a hyperlink to each tab to save me scrolling across...

I have a third party website that I can export data from. In that data are text values that represent Hyperlinks, but Excel does not immediately recognize them as Hyperlinks. Editing the cell without changing the text allows Excel to see that it is a hyperlink, but that technique is obviously...

I've seen formulas on replacing hyperlinks, etc but what i need is to identify a hyperlink that doesn't work (column X) if the hyperlink doesnt work return a value in the column next to it or something similar. Any help would be greatly appreciated.

Hi All, I have just started a work book and the 1stsheet has lots of hyperlinks which works fine, I now want to duplicate theformat including hyperlinks and make about 10 copies/worksheets, unfortunately thehyperlinks on the new worksheets still ping back to the original sheet, isthere any quick...

I read a post from a few years ago addressing this issue but it did not resolve my problem. I have a workbook with 12 sheets in it, and each sheet has a copy of the 'table of contents' consisting of hyperlinks to each other sheet. - I am using Excel 2013 - my workbook has 12 sheets - hyperlink...

Hi guys, while I've been using the site for many years as a guest I've only just joined. I must say thanks for all that you guys do in helping complete strangers. Right, down to business. I have a set of hyperlinks on a masterdata sheet and a "cover sheet" with several vlookups. how can I...

Hi, Hoping that someone can help with a hyperlink / VBA problem that's driving me crazy!? Basically, I have a workbook with a front sheet which contains a column of hyperlinks to other sheets within the same workbook. Each of these hyperlinks is built using the =HYPERLINK formula rather than a...

Can someone tell me how I could follow a hyperlink that comes from the HYPERLINK() function without clicking on it using the mouse? No VBA solutions that I have found through google have worked for me. Please note that this is different from following an inserted hyperlink. There is no context...

Need I have a file where in column “C” I have a list of different hyperlinks to excel workbooks stored on SharePoint (number of rows and links is different every month, but approx. 140). I want to retrieve information from these hyperlinks (the information needed is all in one range on a hidden...

Hi all, Wonder if you can help me with the below. I've had a look through the forums, and I've been unable to find a resolution! I'm creating a monitoring tool for some colleagues. Each supplier has their own tab (called "Fake 1", "Fake 2" etc in the sheet I've shared) which my colleagues can...

I have a userform that has an image element on it. Depending on what criteria the user selects, the picture changes. It also has a function that follows a hyperlink on click. However, the picture will not change after following the link. 'Portion of the main code that alters the image...

Hi there I have a worksheet with 8 Sheets. The first sheet is a summary and I’ve created hyperlinks to 3 of the other sheets for a person to access from the main page. [Sheet names: Premium Breakdown (Sheet 1), PA Group Rank (Sheet 2), 2016 Premium Breakdown (Sheet 3), 2017 Premium Breakdown...

I have over 3,000 Hyperlinks that I would like to change the name to match names listed in another column. Example I have names listed in Colum A and corresponding hyperlinks in columns I and J (hyperlink 1; and hyperlink 2). I would like to change the hyperlink names in both Columns to simply...

I made a table with several links to other spreadsheets for our membership files, however I missed a member who I need to add. So I am trying to add this member but it will not let me without this message popping up, "This wont work because it would move cells in a table on your worksheet."