| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One-click Automatic Charting | Charts and Charting in Excel | |||
| If I click a hyperlink it pops up and goes away | Excel Discussion (Misc queries) | |||
| Why when I click on a pivot, form Getpivotdata isn't automatic | Excel Discussion (Misc queries) | |||
| How do I add hyperlink to Right click | Excel Worksheet Functions | |||
| Double-Click a Hyperlink | Excel Worksheet Functions | |||
Linear Mode
