Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink focus and default email program ?
Hi;
Is there a way, preferrably using macros / VBA, to change the action of Hyperlinks? Right now, some of my users find that if they inadvertently click once on a hyperlink they end up getting an email program ('Word") which they didn't intend. Can I change calling hyperlink action to a double click or Ctrl-click or something more deliberate. Secondly, how can I set up a preferred email program for Excel hyperlinks for each different user? Baseing it on login name would do. Regards Bill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink focus and default email program ?
You can't change the real hyperlink, but you can use the beforedouble click
event to react to a double click on the cell. Put a string in the cell and make it look like a hyperlink by formatting it as blue with an underline. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) if Target.count 1 then exit sub if not intersect(Target,Range("B9,B13,B16,B23")) is nothing then Cancel = False select Case Target.Address(0,0) Case "B9" ThisWorkbook.FollowHyperlink "actual hyperlink string" Case "B13" Application.Goto Worksheets("Sheet6").Range("F11"), True Case and so forth There is a registry setting for the default mail program, but I don't have any information on it. Perhaps someone else will jump in. You might want to use the hyperlink Mailto: command. That should use the default mail program. http://tinyurl.com/zc44h See Gary's post and of course Ron de Bruin's links. -- Regards, Tom Ogilvy End Sub "Bill Case" wrote: Hi; Is there a way, preferrably using macros / VBA, to change the action of Hyperlinks? Right now, some of my users find that if they inadvertently click once on a hyperlink they end up getting an email program ('Word") which they didn't intend. Can I change calling hyperlink action to a double click or Ctrl-click or something more deliberate. Secondly, how can I set up a preferred email program for Excel hyperlinks for each different user? Baseing it on login name would do. Regards Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the default email program in Excel 2007? | Setting up and Configuration of Excel | |||
Default Program | Excel Discussion (Misc queries) | |||
Default Program | Setting up and Configuration of Excel | |||
VBA Program to Email-able Toolbar | Excel Programming | |||
Shut off email address from linking to email program? | Excel Worksheet Functions |