hyperlinks macro

  1. gmooney

    VBA for Hyperlinks

    Hi, I have the following code (which currently gives me an error) that launches a website from a list of URLs in my spreadsheet. The code will launch the URL, which then requires me to login to the site and then go to the proper URL but I get an error message. However, if I simply go click on...
  2. D

    Creating hyperlink for specific sheets while creating those sheets

    i wrote a code that will create as many worksheets and name them for each cell value in a named range. my code gets my template sheet, and duplicates it and renames each one accordingly. on my template sheet, i have a navigation pane in column A, so from A17 downwards, id like to create...
  3. K

    Highlight the cell after clicking on the hyperlink in the cell

    Hello experts, I have an excel table which has hyperlinks in column D. I want to change the color of the cell to green after clicking on the hyperlink. What I want is not to highlight the active cell. I want the cell to have its color permanently after clicking on the hyperlink once. Can...
  4. K

    Error 1004 - Add Hyperlinks to a range with Cell Value in string on Open - Doesn't work when opening in Shared Mode

    Hi, I have the following piece of code running when opening a workbook. I want this workbook to be shared, but when I open in shared mode this piece of code gives me a run-time error '1004': Application-defined or object-defined error. Works fine when not in shared mode. I have googled...
  5. M

    Using VBA to add hyperlinks to a range

    Hi, I'm trying to add hyperlinks to a range of cells that will link them to a specific cell on the correct worksheet. For example, I create my range and populate it with a list of names. Now I want to add hyperlinks to those names (on sheet 1) that will link to cell B2 on sheet 2. The sheet...
  6. P

    Create Hyperlink in a Cell to a Worksheet Name

    Hello - I have an excel worksheet of about 150 lines(inventory control project). Column B in this sheet contains unique serial numbers. I have written a macro to create 150 separate worksheets and the name of each worksheet automatically comes from each unique serial number in column B. All...
  7. K

    Creating a hyperlink to a file .

    Hi all, i want to create a hyperlink to all entries in Column to open a file with the name as in cell. For Ex:- <tbody> Name Link1 link2 JOHN JOHN.PDF JOHN.JPG ROBIN ROBIN.PDF ROBIN.JPG JOY JOY.PDG JOY.JPG </tbody> and so on, I have appx 1000 such entries. I want to open these files...
  8. L

    Hyperlink breaks at space in folder name when using a variable that pulls from a cell value

    I have created a spreadsheet that allows me to drop in a few bits of information and using a macro it sends out a form email through Outlook. I am using Office 2013. Within the document I have a cell that contains a formula that returns the file path of a hyperlink I want to include in the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top