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

J

Jamie

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!
 
P

Pranav Vaidya

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,
 
Top