Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 115
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 227
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 115
Default Launch "Browser URL" when Cell clicked

thanks
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
Right clicked range highlights in Excel would add the "$" to func ebeiss Excel Worksheet Functions 0 July 24th 06 07:20 PM
Have excel "cell" launch PDF viewer for stored file I have Redbobber Links and Linking in Excel 1 April 25th 06 04:05 PM
setup a spreadsheet that would enter an "X" when cell is clicked DanW Excel Worksheet Functions 1 February 16th 06 08:21 PM
how can I make an excel cell "mark" or "unmark" when clicked on? Rick Excel Discussion (Misc queries) 6 January 8th 06 10:15 PM


All times are GMT +1. The time now is 03:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"