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

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!

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

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,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Jamie" wrote:

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!

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

I odn't know how to do that. Can you explain, or do you know another way.

"Pranav Vaidya" wrote:

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,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Jamie" wrote:

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!