View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default How Do You Stop Annoying Excel Message Boxes?

Colin Hayes wrote...
I have a worksheet with a hyperlink to a program outside Excel. This
is working fine at this point with one exception. Every time you
click on the link Excel puts up a message box stating the following:

....
This is really irritating , as it pops up every time. How can I stop
it popping up?

....

Another alternative that would leave standard warnings in place while
running outside .EXEs would be to use the FollowHyperlink event
handler. Name the cell that will contain the hyperlink RunEXE, insert
the hyperlink referring to the defined name RunEXE, so its own cell,
then put the following into the class module for the worksheet
containing this hyperlink.

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.SubAddress = "RunEXE" Then _
Shell "c:\winnt\system32\winver.exe", vbNormalFocus
End Sub

This just runs the Windows version applet, but compare it to a
hyperlink referring directly to file:///c:\winnt\system32\winver.exe.