Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the following macro to run whenever B2 is selected:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address < "$B$2" Then Exit Sub On Error Resume Next Application.EnableEvents = False MsgBox ("hi") Application.EnableEvents = True End Sub The macro works just fine; click on B1 and the macro runs. B1 contains a hyperlink. The click also causes the hyperlink to be followed (simultaneously??). Is there anyway I can force the macro to execute completely before the hyperlink gets followed? -- Gary's Student |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet_Change or Worksheet_SelectionChange | Excel Programming | |||
Worksheet_SelectionChange | Excel Programming | |||
Worksheet_SelectionChange | Excel Programming | |||
Worksheet_SelectionChange | Excel Programming | |||
Worksheet_SelectionChange | Excel Programming |