Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting a hyperlink to follow a sort | Excel Discussion (Misc queries) | |||
follow hyperlink? | New Users to Excel | |||
follow hyperlink? | Excel Worksheet Functions | |||
follow hyperlink? | Excel Programming | |||
Follow a hyperlink | Excel Programming |