LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 550
Default Follow Hyperlink in Cell

I have a 3 column range on a sheet.
The first column populates a combobox on a form.
The 3rd column is a hyperlink to subfolder on a server.
Example: X:/MRASpreads/123Forms/Amendments

When I access the sheet itself and click on the cell with the hyperlink,
everything works
fine and I don't get any warning messages. Explorer just opens up in that
subdirectory.

I'm trying to get explorer to open up via code.
The following works:
ActiveWorkbook.FollowHyperlink Address:= _
Application.VLookup(ComboBox3.Value, Range("FullLocn"), 3, False), _
NewWindow:=True

The problem with the above is that it displays the virus warning message
before
opening up explorer. I've read that the warning can't be disabled but since
this
can be done directly from the worksheet, there must be another (better) way
to
do this than the way I'm trying to it.

Any ideas?

Thanks,
John


 
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
Getting a hyperlink to follow a sort Andybanker Excel Discussion (Misc queries) 7 June 26th 06 07:39 PM
follow hyperlink? JethroUK© New Users to Excel 0 April 5th 06 09:55 PM
follow hyperlink? JethroUK© Excel Worksheet Functions 0 April 5th 06 09:55 PM
follow hyperlink? JethroUK© Excel Programming 0 April 5th 06 09:55 PM
Follow a hyperlink James W.[_2_] Excel Programming 2 December 4th 04 12:41 AM


All times are GMT +1. The time now is 06:41 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"