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

Follow Hyperlink in Cell
 

Darn!! Where is Mr. Ogilvy when I need him??

Rephrased.......
I have a hyperlink on a worksheet and I want to simulate a "click" on that
cell via VBA so that I won't get that darned virus warning message.


"John Wilson" wrote in message
...
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