Launch "Browser URL" when Cell clicked
 

In the same type of event, can I launch a new browser window to a fix URL
when AC1 is clicked?

If Target.Address = "$AC$1" Then
'launch http://www.myurl.com in a separate IE window
End If

Launch "Browser URL" when Cell clicked
 

Hi

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$AC$1" Then _
ActiveWorkbook.FollowHyperlink Address:="http://www.myurl.com", _
NewWindow:=True
End Sub

--
XL2003
Regards

William



"CRayF" wrote in message
...
In the same type of event, can I launch a new browser window to a fix URL
when AC1 is clicked?

If Target.Address = "$AC$1" Then
'launch http://www.myurl.com in a separate IE window
End If

Launch "Browser URL" when Cell clicked
 

thanks