I do not want a hyperlink to be automatic when you click on that c

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet with multiple hyperlinks. I want the hyperlink to
remain active, but I don't want it to be automatic when someone clicks in the
cell. I want them to have to follow a specific set of commands to link to
the website. Can anyone help? I've opked around and tried to find a
solution but didn't see anything. Thanks!
 
Hi Jamie,

I think you will have to write a VBA routine for this.
You will have to use 'followHyperlink' event of the worksheet object.
This event occurs when you click on any hyperlink on the worksheet.

HTH,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can you hyperlink to a hyperlink? 1
Can UDF return a customized hyperlink? 3
HYPERLINK AND VLOOKUP help 1
VLOOKUP return cell location and hyperlink 0
Activating hyperlinks 3
The hyperlink reference doesn't changes when I insert Rows and co. 2
Excel hyperlink to another open Excel file - wants to reopen file 1
How do I get Excel to automatically calculate the value of a hyper 2

Back
Top