1. R

    VBA UserForm picture won't change after _Click() function executes

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

    Hyperlinks to Hidden Sheets - Beginner Excel User

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

    Change large number of hyperlink names

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

    Table with links, not letting me add a row in-between

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

    Hyperlinks with Pictures and Drop Down Lists

    I am just a common user of Excel trying to do uncommon things and wishing I could do more. Would appreciate answers written in "layman's" terms as I certainly don't understand anything related to coding such as VBA. :confused: Working on a project that is intended to be used by people who know...
  6. C

    Hyperlinks to a Worksheet within the same Workbook

    Hi, I am using Excel 2013 and I am experiencing a problem trying to create a number of Hyperlinks from two Worksheets to a third within the same Workbook. In the Workbook there are three sheets. The first Worksheet is pretty constant whilst the other two change on a weekly basis. Worksheet 2...
  7. I

    Trigger a macro via a hyperlink

    Hi there, I have a series of hyperlinks on a tab that when clicked i want to hide/unhide specific rows. I have looked around online and realize i cannot have more than one Worksheet_FollowHyperlink but that i can build a macro that calls on other macros to work around this. i have built...
  8. L

    Pivot Table Hyperlinks

    Hi, I need my Master Data Table to transfer Hyperlinks to Pivot table. I have seen lots of VBA coding, however not much for hyperlinking to computer files and not web links. Can anyone help me?
  9. cgendron

    Create Hyperlinks

    Hello all, I have a list of website bookmarks, not hyperlinked, just text. They are all listed in column A. I know i can select each one and choose "hyperlink" and copy the link and paste it to manually create a hyperlink but is there a formula to automatically create the hyperlink? I have a...
  10. D

    Google sites link to excel cell content opening a web hyperlink

    I would like to use a Excel sheet to manage the links on several google sites, such that I create links on my sites to the contents of a cell in an Excel spreadsheet, which contains a link to another document. This would enable editors of the spreadsheet to change the results of the links in the...
  11. How_Do_I

    Open Multiple Hyperlinks

    Hello, I have a workbook with hyperlinks to files on my PC. How can I highlight a range of these hyperlinks and have them all open please? They are all pdf files if that makes a difference.
  12. A

    Two Questions Regarding: How to import hyperlinks with Importing external data from web, & Formula fill not working

    Hi everyone i have two questions i need help with. 1st. Is when i am using external data that is imported into excel from the web, Hyperlinks on the websites table does not get transferred into excel but instead just text. Is it possible to change this so it imports working hyperlinks. (Using a...
  13. D

    VBA code to extract outlook mail to Execl which is ib table format

    Hi, I have outlook email which is in table format and the content in the table has data with Embed Hyperlinks. I tried the below code. I am getting all the data from the table to excel but i am not getting the Embed Hyperlinks. Can you please help in getting the Hyperlinks which are Embed to...
  14. D

    Paste Special Column of Hyperlink Formulas

    I have a spreadsheet where the basic function is to merge information from two worksheets. One sheet has a column hyperlinks (to external web pages) and a unique date for each row. The other sheet has descriptive information, tags, etc. I now have all the data merged, sorted, and formatted the...
  15. 1

    Macro to change a part of hyperlinks

    Hello, I have a big Excel file with many worksheets&hyperlinks to other documents all over my PC. After I update to Win10 the path for documents (and hyperlinks) is changed: Old = C:\Users\nzw\AppData\Roaming\Microsoft\Excel\... New = C:\Users\nzw\AAA\... The "..." contains the rest of path...
  16. Jaafar Tribak

    Check if Hyperlink has been previously clicked ?

    Hi all, As you know, when an hyperlink is clicked in excel or in other applications, its text color changes visually indicating that the link has already been followed. The color is reset to its default when re-opening excel. (Depending on the update automatic links at open setting) I am...
  17. M

    Excel Hyperlinks - activate a message box... VBA christmas!

    I have an excel workbook with a bunch of hyperlinks built into the worksheet cells. These hyperlinks all point to other cells/sheets within the same workbook. The problem is that people keep accidentally clicking the hyperlinks, and getting involuntarily bounced around the workbook. I'm...
  18. D

    Non working Hyperlinks when results returned from another sheet

    I have the following problem. Sheet 2 has a list of names and hyperlinks to other sheets (hyperlinks work) On sheet one I have created an” Index - Small” formula that searches sheet2 and brings back the results on sheet1...
  19. N

    Hyperlinks in Excel have changed? How can I easily change them back?

    I have a spreadsheet that is used to maintain stock in a warehouse. As below: Column A had hyperlinks in it that linked to folders and excel spreedsheets on a NAS storage drive. However since a computer update the links have changed. As you can see in the image below I have highlighted one...
  20. E

    Need to change address of named range as list is filtered

    Hello - I have a list of hyperlinks that open a userform. Each hyperlink is tied to a unique row of data in the range. The hyperlinks each refer to a unique named range based on the data in that row. I need users to be able to filter this list in order to organize the rows in various ways. My...

Some videos you may like

This Week's Hot Topics