View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pranav Vaidya Pranav Vaidya is offline
external usenet poster
 
Posts: 180
Default 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!