Glad to hep
Don Guillett
SalesAid Software
dguille...@gmail.com
-----Original Message-----
From: renuka chari
Sent: Wednesday, February 15, 2012 12:27 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ need help for hyperlink execution without
using mouse PFA
Hi
dguillett1
Its working Good Thank you so much
On Feb 14, 10:44 am, "dguillett1" <dguille...@gmail.com> wrote:
Right click sheet tab>view code insert this. Now when you select col G (no
need for col H)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error GoTo nomo
If Target.Column = 7 And Target <> "" Then
ActiveWorkbook.FollowHyperlink Address:= _
"mailto:"; & Target & "?bcc=$J$1," & Target & "), NewWindow:=True"
End If
nomo:
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Renukachari Kasee
Sent: Tuesday, February 14, 2012 6:21 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ need help for hyperlink execution without using
mouse PFA
Hi
All experts
good evening
here one sheet is having hyperlinks click on that link(with the help of
mouse) outlook new mail window will be open,
but i am expecting without using mouse.
(¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!!
`•.¸.•´
Thanks & Regards´¨)
¸ •´ ¸.•*´¨) ¸.•*¨)
(¸.•´ (¸.•* ♥♥♥...♪♪♪....RenukaChari. Kasee...♥♥♥...♪♪♪
P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and use
renewable energy sources.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---------------------------------------------------------------------------
---------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
