hyperlinks

Hi I am having problems inserting Hyperlinks in unlocked cells on protected worksheets. With the help of this forum I have been successfully using the code below to auto filter However, I have noticed after this code is run, I am unable to insert a hyperlink in the unlocked cells. I have...

I am having problems with losng my hyperlinks when I save the exel spreadsheet to another workbook name. Is there any way to save my hyperlink info to another workbook so it appears in the new workbook. Any help would be greatly appreciated!!

I created a monster. I have a workbook that isbeing used as an index of all our documents. Each row represents one document and each row is made up of several columns. Each row has a hyperlink that spans the entire number of columns . The hyperlink is to a scanned document on the network. They...

How can I retain the hyperlinks when I save my excel file to a new name

I have a column of unique text values that are URLs (web addresses). I need to convert all of them to hyperlinks that point to the unique URL but want all of the rows to display the same text. My actual dataset is hundreds of rows. Data www.1234.com www.5678.com www.9101.com Desired output...

I have created several worksheets including one that holds my look up tables (worksheet labeled tables). I also have another worksheet called "Directions". In the "Tables" worksheet I have an array with three columns, the first holding the text value I am searching for, column two which contains...

Can anyone help me please? I have a workbook with multiple worksheets. Worksheet#1 is the one that the user will beactively using. It has hyperlink to other worksheets within the sameworkbook. These other worksheets areinformation only. When I hide the otherworksheets, the hyperlinks stop...

Hello need a little help "YouTube": Hyperlink function from drop down menu data validation list throughout entire workbook "YouTube": https://www.youtube.com/watch?v=3vRkA_7x9t8&t=50s The validation link hyperlink listed above works great but it links to other sheets and I need it to link on...

This bit of code does a great job of listing all folders and files in a directory to a sheet. Sub cmdList() Dim sPath AsString Dim fOut AsVariant Dim r AsInteger Dim Cell As Range With Application.FileDialog(msoFileDialogFolderPicker)'.Title = "Select directory"...

Is there a way to place multiple hyperlinks in a single text box? Every time I select some text to make into a hyperlink, it makes the entire text box the link. I have a long Excel workbook comprised of long text boxes for ease of alignment purposes. I'm using Excel instead of Word because...

When creating a hyperlinks for other users, upon looking further, hovering over the link it shows the directories, the file path of MY computer. i'e. file///C:\Users\User\Documents\Excel\filename.xlsm. No wonder I can't share it. Thanks, ~Jim

I'm wondering if anyone can help me with working out how to add a hyperlink based on certain conditions. I have two worksheets - Worksheet "Catalogue" has a dropdown list to select which fruit and another worksheet which has information about the piece of fruit selected. There are multiple...

Hey all! I scoured the internet and I'm either not finding how to achieve this, or I'm describing my need incorrectly. Hopefully someone can help here! Basically I created a calendar in excel. I want to be able to click on a date, and have that date appear in another cell. Is this possible...

I have a rather large workbook that has a 'Template Page' where the default page styling, formulas, and tables reside. I have a Macro that clones the page, and then auto updates the formulas to refer [NewPage] instead of [Template] page. All works well, no issues. Then now they want to put in...

Keep getting a error This Location may be unsafe. Hyperlinks can be harmful to your computer and data, click only those hyperlinks from trusted sources. How do I turn this off or add as a trusted source?

Hello all, I have a predicament where if i run a hyperlink checking VBA sub i may not see my computer for the rest of the evening as it will check over 100,000 hyperlinks Is there any way to have it only check the first of every hyperlink? basically there are duplicate hyperlinks and i would...

Hi Everyone - I've got about 300 cells that need hyperlinks added The cells all have the same format - The value is PI-XXXX and the hyperlink is https:\\I-am-lazy\PI-XXXX In a perfect world I'd simply create a helper column using the hyperlink function, but I"ve been specifically instructed...

Hello, Is there a way to keep a range of hyperlinks working on a protected sheet? I only want to select unlocked cells for protection please. This sheet is for filling out data so I want to keep the cursor in the unlocked region. Thank you, XJ

hi,i want a solution of my problem in VBA:I have a main page (a directory for all the sheets) which is hyperlinked to numerous sheets and all have hyperlinks to take me back to the main page and the sheet hide automaticaly . My problem is when i protect workbook (structure protection) the...

Hi, I currently have 2 spreadsheets, where I am using the "Get Data" function to pull data from one to the other. One of the columns I am pulling through contains "hardcoded" hyperlinks (not using any formula), where the content of each cell is the name of a file, and the hyperlink to said...